Interested to Buy Any Domain ? << Click Here >> for more details...
How we can get unique records into one target table and
duplicate records into another target table??
- 11 Answers
- 41267 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 dimensional table?
What is target load order?
How many dimensions are there in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What do you mean by worklet?
difference between informatica 8.1.1 and 8.6
What is enterprise data warehousing?
In informatics server which files are created during the session rums?
Quickly characterize reusable change?
Explain the mapping variable usage example in informatica
How would you join a node to the already existing domain?
Have you worked with/created Parameter file
How to generate sequence numbers?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is a dimensional model?
