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
- 41686 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 standalone command task?
have u done any performance tuning? how u ll do?
How can we delete duplicate rows from flat files?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is Session and Batches?
Please let me know how to make encryption and decryption with example?
What is depict expression change?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Difference between Data and Index Caches?
What are the different versions of informatica?
Whats there in global repository
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
what is index?how it can work in informatica
