Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7343 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 |
What are the different types of Type2 dimension maping?
Discuss the advantages & Disadvantages of star & snowflake schema?
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
In which scenario did u used Mapping variable?
What is the sequence generator transformation in informatica?
comonly how meny mappings r there in Banking projects?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
How to load data in informatica ?
What are multi-group transformations?
In informatica workflow manager, how many repositories can be created?
Explian the connected and unconnected lookup transformation
Teradata 
