hw cn v elimate dublicate values from lookup without
overriding sql?
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
Separate from a database, an information bazaar, and an information stockroom?
COM components can be used in Informatica
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What do you mean by worklet?
Can we create multiple integration service on single repository?
Explian the Process of deployment groups in informatica
Which are the different editions of informatica powercenter that are available?
Explain pushdown optimization $pushdownconfig parameter - informatica
Explain sessions?
scenario where i can use only concurrent execution of workflow.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
tell me the rules and responsblites in our project(my project is development)
Sequence generator, when you move from develoment to production how will you reset
According to his methodology what all you need before you build a datawarehouse