There will be 5 questions from this topic. What to study & Where to focus Workflow Basics Guide Chapter 14: Session and Workflow Logs Message Severity (Page 239) Log Events Window (Page 241) Workflow & Session Logs (Page 246) Advanced Workflow Guide Chapter 8: Row Error Logging General topics What are the scenarios/reason when a […]
Read MoreCategory: PowerCenter Certification
05 Transformation language: Tips for Informatica PowerCenter Specialist Certification!
There will be 6 questions from this topic. There is one entire pdf document is talking about this topic. You can download the document from the below url. This describes how you can use constants, operators, variables, dates, and functions to transform source data. Transformation Language What to study & Where to focus Even-though its […]
Read More04 Parameters & variables: Tips for Informatica PowerCenter Specialist Certification!
There will be 6 questions from this topic. You can go through the below sections in the Informatica PDF document to learn about Parameters & variables. Designer Guide Chapter 7: Mapping Parameters andVariables Advanced Workflow Guide Chapter 15: Parameters and Variables inSessions Chapter 16: Parameter Files What to study & Where to focus Mapping Parameter […]
Read More03 Sample Questions! Informatica PowerCenter Specialist Certification.
Informatica PowerCenter Data Integration 10: Developer, Specialist Certification. This is the third video in the tutorial series. This will give you some idea about the sample questions. Please do like and subscribe the channel for more videos. Liked the content?? Please Like FB page & subscribe the channel! Let’s learn together!
Read More02 Exam topics! Informatica PowerCenter Specialist Certification.
You can find all the required Informatica PDF documentation in the links below! Informatica Documentation center Getting started: Transformation Guide: Designer Guide: Transformation Language Reference Workflow Basics Guide: Informatica PowerCenter Data Integration 10: Developer, Specialist Certification. This is the second video in the tutorial series. This will give you clear idea about the test topics, […]
Read More01 Things to know! Informatica PowerCenter Specialist Certification!
Informatica PowerCenter Data Integration 10: Developer, Specialist Certification. This video will give you some basic informations about this certification exam. This is the first video in the tutorial series. Please do like and subscribe the channel for more videos. Liked the content?? Please Like FB page & subscribe the channel! Let’s learn together!
Read MoreHow to create a Reusable task in Workflow Designer?
Can we create a Reusable task in Workflow Designer? The answer is yes. When you create a task in workflow designer its non-reusable by default. But you can always promote this to a reusable task. This action cannot be reversed. Creating a Task in the Workflow or Worklet Designer You can create and add […]
Read MoreInformatica 10 Developer Specialist Certification – Enroll Now!
When You Are Ready To Test: Informatica Specialist Certifications are available Anytime/Anywhere. To become an Informatica Certified Specialist (ICS), please follow these steps. 1. Go to the Informatica Certification Trainings located here. 2. Login with your Informatica Passport or create your account. 3. Locate the Certification you wish to take, click Certification under the title. […]
Read MoreInformatica 10 Certification – Sample questions
PowerCenter Data Integration 10: Developer, Specialist Certification This test measures your competency in building PowerCenter objects on basic and advanced levels in order to make optimal use of the Designer, Workflow Manager and Workflow Monitor tools. Additionally you will be tested on your ability to use transformations, build and run workflows, and further test your […]
Read MoreInformatica 10 Certification – Developer Specialist
PowerCenter Data Integration 10: Developer, Specialist Certification This test measures your competency in building PowerCenter objects on basic and advanced levels in order to make optimal use of the Designer, Workflow Manager and Workflow Monitor tools. Additionally you will be tested on your ability to use transformations, build and run workflows, and further test your […]
Read MoreXML Transformations
XML Transformations in Informatica What are the different types of XML transformations? Ans:- XML Source Qualifier Transformation, XML Parser Transformation and XML Generator Transformation. What is XML Source Qualifier transformation? Ans:- It defines the data elements that the integration service reads from a XML source definition. XML Source Qualifier transformation is an ……. transformation? Ans:- […]
Read MoreSQL Override in Informatica
We have an option to customize the default query provided by the transformations and enter custom SQL query by using SQL override. The most common transformations which support the SQL overrides are Source Qualifier & Lookup transformations. If a table name or column name in the lookup query contains a reserved word, enclose the reserved […]
Read MoreInformatica certification – Commit Points
What is source based commit? Ans:- The Integration Service commits data to the target based on the number of rows from some active sources in a target load order group. What is One-to-One mapping? Ans:- One-to-one mapping is a mapping that moves data from a Source Qualifier, XML Source Qualifier, or Application Source Qualifier transformation directly […]
Read MoreInformatica certification – Rank Transformation
How many Ranks ports are allowed in a Rank Transformation? Ans:- Only ONE. What is RANKINDEX? Ans:- It is an output port to which the integration service store the ranking position for each row in a group. Why Rank is an active transformation? Ans:- Rank transformation might change the number of rows passed through it. Can we […]
Read MoreInformatica certification – Update Strategy Transformation
Update Strategy Transformation – My Notes How rows are flagged for insert, update, delete, or reject within a mapping? Ans:- Using Update Strategy transformation. We can also use the Custom transformation to flag rows for insert, delete, update, or reject. What are the different levels we can configure update strategy? Ans:- (1) Within a session, […]
Read More