How we can get unique records into one target table and
duplicate records into another target table??
- 11 Answers
- 37555 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 is the use of target designer?
What is the difference between source qualifier transformations source filter to filter transformation?
Explain what transformation and how many are there in informatica?
What is a passive transformation?
What is decode in static cache?
Define joiner transformation?
What do you mean by channel change?
What does command task mean?
Explain transaction control transformation in informatica
Performance tuning( what you did in performance tuning)
What is rank transformation?
What is Cognos script editor?
How to extract sap data using informatica?
Explain about Informatica server process that how it works relates to mapping variables?
How can we remove the duplicates from flat file source?
