What is the main purpose of Unconnected lookup other than
updating slowly changing dimensions?
or In which case u use Unconnected lookup?
- 2 Answers
- 6417 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ratalarayudu
hi,
The main purpose of unconnected lookup t/r is
1.To update slowly changing dimensions
2.if we want to use the same lookup multiple times in a
mapping we can go for unconnected lookup
3.if we want to lookup on only selected rows then we can go
for unconnected look up.
regards,
rayudu.
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / praveenabhaskar
We can use unconnected lookup transformation when we have
multiple inputs and single output.
| Is This Answer Correct ? | 3 Yes | 2 No |
Do joiner transformation use cache? If so describe?
What is a node in Informatica?
how i will stop my workflow after 10 errors
what is the dashbords?
what is distinct
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
difference between informatica 8.1.1 and 8.6
What are Rapid changing dimensions?
Without using any transformations how u can load the data into target?
Design time, run time. If you don't create parameter what will happen
how to join the two flatfiles using the joiner t/r if there is no matching port?
What is decode in static cache?
Teradata 
