hw cn v elimate dublicate values from lookup without
overriding sql?
- 7 Answers
- 15677 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
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Define update strategy?
how tokens will generate?
What do you mean by enterprise data warehousing?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is a standalone command task?
How to generate sequence numbers?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Explain the difference between mapping parameter and mapping variable?
How to do unit testing in informatica?
Is it possible to create multiple domains on a single Informatica server?
Write the different tools in the workflow manager?
What are the different types of repositories created using informatica?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What can we do to improve the performance of informatica aggregator transformation?
