What is the method of seperating unique and duplicate
records in session level?
Answer Posted / jz
Select Distinct Box at Source propeties level or jus
override sql in Session.
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
What do mean by local and global repository?
How to do unit testing in informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
Why filter transformation is an active one?
waht type of interface is used for testing the data in informatica
How do you load only null records into target? Explain through mapping flow.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How to load data in informatica ?
What is DR strategy for Informatica project?
What is the use of an aggregator cache file?
I have a flat file, want to reverse the contents of the flat file
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Differentiate between source qualifier and filter transformation?
What is the meaning of up gradation of repository?