Interested to Buy Any Domain ? << Click Here >> for more details...
How do you avoid duplicate records with out using source
qualifier,expression,aggrigator,sorter and lookup
transformations ?
- 4 Answers
- 11128 Views
- IBM, I also Faced
- E-Mail Answers
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
differences between service based and product based?
What is the need of an ETL tool?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is expression transformation?
In how many ways we can create ports?
Enterprise data warehouse your projects phase by phase explain?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is an unconnected transformation?
What do you mean incremental aggregation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is a node in Informatica?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is update strategy transform?
What is a joiner transformation?
