Source is a flat file and want to load unique and duplicate
records separately into two separate targets; right??
Answer Posted / ankit kansal
Hi,
What i have understood after seeing your problem is like if your source contains 1,2,1,2,3 then only 3 is taken as unique and 1,2 will be considered as duplicate values.
SRC->SQ->SRT->EXP(to set flags for dup)->ROUTER->JOINER->EXP->RTR->2TGTS
http://deepinopensource.blogspot.in/
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
is it possible to index the data in cache of lkp transformation ?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What are the advantages of informatica?
What is a mapplet/worklet in informatica?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is informatica powercenter repository?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How would you copy the content of one repository to another repository?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Explain pushdown optimization $pushdownconfig parameter - informatica
What are the different lookup cache(s)?
What do you understand by a term domain?