On lookup on any table we can get only a)any value or b)last
value but if i need both duplicate values How can i achieve?
- 3 Answers
- 6482 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pradeep
We wil go for left outer join on the lookup table in the
source qualifier sql override so that it wil return both the
records.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / suresh
actually on lookup two ways we can put the values normally
we put a anyvalue(if you want to both duplicate values).
when we use SCD type 2 its must and should put on last value
into the look up Bcoz it should store the history.
| Is This Answer Correct ? | 2 Yes | 2 No |
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
difference between repository database and repository service?
what is worklet and what use of worklet and in which situation we can use it?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is the Difference between DSS & OLTP?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
What is the use of code page?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are the different types of schemas?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
Teradata 
