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
- 40665 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 persistent lookup cache?
Enlist the various types of transformations.
What are the types of data warehouses?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is rank transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Performance tuning( what you did in performance tuning)
What is lookup transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Briefly explain the aggregator transformation?
How to do unit testing in informatica?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is Cognos script editor?
