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
Partition, what happens if the specified key range is shorter and longer
How identifying bottlenecks in various components of informatica and resolving them?
What are the differences between source qualifier and joiner transformation?
How can we use mapping variables in informatica? Where do we use them?
In development project what is the process to follow for an etl developer from day1
What is option by which we can run all the sessions in a batch simultaneously?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are ETL Tools?
What do you understand by term role-playing dimension?
What is meant by query override?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the types of data warehouses?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Explain what is informatica metadata and where is it stored?