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
- 41170 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
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is workflow? What are the components of workflow manager?
What is workflow manager?
What is a transaction control transformation?
what is the size of your data warehousing?
can you please explain me pre session and post session options?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
update strategy transformation in informatica
What is the need of an ETL tool?
How to load a Dimension ? and how to load a fact table?
What is the difference between STOP and ABORT options in Workflow Monitor?
How will the document be delivered to me?
explain about unit testing? in real time?
can u any challenge your project?
What is rank transformation?
