what r d pre-requiste for update strategy transformation,
and differnce between delete n truncate in target session
properties for update strategy
Answer Posted / vikas
Update Strategy Works on Tables and not on files. In session, Treat source rows should be data driven.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Write the unconnected lookup syntax?
What is the cumulative sum and moving sum?
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.
Explain 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?
How do you load only null records into target? Explain through mapping flow.
what is the size of your data warehousing?
What is the use of an aggregator cache file?
What is olap (on-line analytical processing?
What are the different clients of powercenter?
How to create the source and target database connections in server manager?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are the types of presistent cache in look up tr.
How to configure mapping in informatica?
How do you load first and last records into target table?
Explain sessions. Explain how batches are used to combine executions?