Interested to Buy Any Domain ? << Click Here >> for more details...
hw cn v elimate dublicate values from lookup without
overriding sql?
- 7 Answers
- 17488 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / preeti
hi,if I understand this question correctly,lookup itself
eliminate duplicate rows by having options like First
Value,Last Value.So whenever there are more than one row
for matching lookup condition then it gets eliminated by
first value.last Value option.Let me know if I am wrong
| Is This Answer Correct ? | 33 Yes | 2 No |
Post New Answer View All Answers
What is dimensional table?
What is a joiner transformation?
What are ETL Tools?
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.
What is an unconnected transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the transformations that are not supported in mapplet?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What all are steps in up gradation of Informatica server?
How to extract sap data using informatica? What is abap? What are idocs?
What do you mean by filter transformation?
What does update strategy mean, and what are the different option of it?
How to convert multiple rows to single row (multiple columns) in informatica
design of staging area?
