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
- 10934 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
What is a joiner transformation and why it is an active one?
What is xml source qualifier transformation in informatica?
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.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
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)
What is persistent lookup cache?
Differentiate between source qualifier and filter transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is data transformation manager process?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
scenario where i can use only concurrent execution of workflow.
Write the unconnected lookup syntax?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the features of complex mapping?
Do you find any difficulty while working with flat files as source and target?
