Interested to Buy Any Domain ? << Click Here >> for more details...
hw cn v elimate dublicate values from lookup without
overriding sql?
- 7 Answers
- 17829 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / bsgsr
hi, preeti,
u r absolutely correct.
the main functionality is to avoid duplicate rows by
selecting first or last value only when the record kming
from the source has multiple matches with the look up cache.
mail meif u r interested in kt
9866188658 bsgsr12@gmail.com
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vijay
using dynamic lookup in lookup t/r we can easily eliminate
duplicates.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / honey
We can remove the duplicate values from the lookup by using
the DISTINCT clause with SQL queries.
| Is This Answer Correct ? | 2 Yes | 6 No |
Answer / chandra
in the source qualifier select the prequalifier and select
the distinct clause
| Is This Answer Correct ? | 0 Yes | 6 No |
Answer / reddy
hi,
we can eliminate duplicate values by camparision primary key
using lookup
| Is This Answer Correct ? | 1 Yes | 7 No |
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
How do you handle decimal places while importing a flatfile into informatica?
what is the difference between Informatica 7.1 and Abinitio?
What is difference between partioning of relatonal target and partitioning of file targets?
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
How to fix the etl bugs..Tell me the process?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
How to elaborate powercenter integration service?
What are the settings that you use to configure the joiner transformation?
Teradata 
