suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping using aggregator & router? how
Answer Posted / sankar
AS PER Reddevilzzzz ANS ALMOST OK
BUT NO NEED TO SELECT GROUP BY IN AGGREGATOR T/R BCOZ IF U
SELECT GROUP BY THERE IS NO DUPLICATE SO WITH OUT
DUPLICATES HOW WE PASS THE DUPLICATES IN T2.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the uses of etl tools?
how we can load rejected record's at run time?(not through bad files)
Make a note of the quantity vaults made in informatica?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
In informatics server which files are created during the session rums?
What is rank transformation?
Define mapping and session?
What is substr in informatica?
What is a sorter transformation?
Describe an informatica powercenter?
Explain what is informatica metadata and where is it stored?
How to partition the Session?
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)
Whats the difference between informatica powercenter server, repositoryserver and repository?