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
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain the types of transformations?
How to start a workflow using pmcmd command?
Explain the aggregator transformation?
What is update strategy transform?
How to do the error handling of if ur source is flatfiles?
Explain incremental aggregation in informatica
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the Rank index port in Rank transformation?
Explain the pipeline partition with real time example?
Name the different lookup cache(s)?
tell me about your project functionality
What are the different ways to implement parallel processing in informatica?