How you load distinct records into one target and duplicate
records into another target?
Answer Posted / hema
With an Expression transformation flag the 1st record of a
group with some value say "VALID" and flag the other
records of the same group with value say "DUPLICATES". Then
pass this through a router and then to the different
Targets.(1st target - records with VALID flag and in 2nd
target - records with "DUPLICATES" flag)
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is the sql query overwrite in source qualifier in informatica
Can informatica load heterogeneous targets from heterogeneous sources?
Separate from a database, an information bazaar, and an information stockroom?
How to load last n records of file into target table - informatica
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are the components of the workflow manager?
What are the types of data warehouses?
What is the session task and command task?
What is a dimensional model?
What is option by which we can run all the sessions in a batch simultaneously?
What do mean by local and global repository?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain about Informatica server process that how it works relates to mapping variables?