How we can get unique records into one target table and
duplicate records into another target table??
- 11 Answers
- 37470 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answer Posted / chandra
FIRST WE TAKE SORTER Tr ,BY USING THIS WE CAN RETRIEVE
UNIQUE RECORDS...NEXT
WE TAKE EXP Tr IN THAT INSERT NEW OUTPUT PORT ..,IN THE
OUTPUT PORT EXPRESSION WRITE COUNT FUNCTION AFTER THAT TAKE
FILTER Tr IN THAT PUT THE CONDITION AS
IIF(COUNT>1,TRUE,FALSE)THEN CONNECT TO TARGET......
SQ-->SORTr-->TARTr1(UNIQUE)
-->EXPTr-->FIL Tr-->TAR Tr2(DUPLICATES)
| Is This Answer Correct ? | 17 Yes | 30 No |
Post New Answer View All Answers
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Different sorts of metadata that stores in the storage facility?
What is substr in informatica?
Explain direct and indirect flat file loading (source file type) - informatica
What are the differences between source qualifier and joiner transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is meant by a domain?
Which version configuration tool used in ur project?
How to extract sap data using informatica?
How you know when to use a static cache and dynamic cache in lookup transformation?
what are the deliverables?in your project?
what is index?how it can work in informatica
How do you load first and last records into target table?
Mention some types of transformation?
Explain the aggregator transformation?
