How do you avoid duplicate records with out using source
qualifier,expression,aggrigator,sorter and lookup
transformations ?
Answer Posted / triveni
rank transformation
ex: empno,ename
1,ramu
1,ramu
2,rani
2 ,rani
empno(group by),ename(returnport) top1 or bottom1
target: 1 ramu
2 rani
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
Explain about cumulative Sum or moving sum?
How to go to the older version for a mapping?
How to handle decimal places while importing a flatfile into informatica?
What does reusable transformation mean?
What all join we can perform in LOOKUP transformation?
tell me the rules and responsblites in our project(my project is development)
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is Index Caches size?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
explain abt ur project architecture?
How to join three sources using joiner?
What is the scenario which compels informatica server to reject files?
How to load the data from a flat file into the target where the source flat file name changes daily?
my source is junk data how will u remove that junk data by using unix please any one replay me