What is the default source option for update stratgey
transformation?
Answer Posted / swetha
Data driven.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are the reusable transformations?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the types of caches in lookup?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is a stored procedure transformation?
What is an Integration service in Informatica?
Which files are created during the session rums by informatics server?
What are the databases that informatica can connect to windows?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain load alternative records / rows into multiple targets - informatica