What is the main purpose of Unconnected lookup other than
updating slowly changing dimensions?
or In which case u use Unconnected lookup?
Answer Posted / 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 |
Post New Answer View All Answers
What is the need of an ETL tool?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How you know when to use a static cache and dynamic cache in lookup transformation?
Plz can any one say me how to get the informatica certification materials and dumps
Make a note of the quantity vaults made in informatica?
What is data transformation manager process?
Explain the informatica workflow?
How to generate sequence numbers without using the sequence generator transformation?
What is source qualifier transformation in informatica?
What is a stored procedure transformation?
how many types of dimensions are available in informatica?
What is informatica metadata and where is it stored?
Slowly changing dimensions, types and where will you use them
Write the program through which the records can be updated?
Does an informatica transformation support only aggregate expressions?