What is the main purpose of Unconnected lookup other than
updating slowly changing dimensions?
or In which case u use Unconnected lookup?
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 |
Target is zero file and how can you send the email?
Separate from an archive server and a powerhouse?
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
What are the types of caches in lookup? Explain them.
HOW TO GET THE LATEST DATA IN SCD ?
What is persistent lookup cache?
whats the logic to load the lower level of granularity of data to fact table.
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
we have to use order by,where,having we to implement sql query
What are the reusable transforamtions?
what is the difference between copy object import objects using repositery manager which one is best