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
- 7351 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 |
Briefly describe lookup transformation?
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
Can u generate reports in Informatica?
Enlist the tasks for which source qualifier transformation is used.
What is deployment group?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Using Connected or unconnected lookup for performance wise which one is preferable?.
What are the informatica performance improvement tips
How do we call shell scripts from informatica?
What aer the out put files that the informatica server creates during the session running?
What are the different types of Type2 dimension maping?
Teradata 
