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



What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or..

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

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or..

Answer / praveenabhaskar

We can use unconnected lookup transformation when we have
multiple inputs and single output.

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More Informatica Interview Questions

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  


What is workflow monitor?

0 Answers  


What is parameter file?

2 Answers  


Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,


what is a time dimension? give an example?

2 Answers   IBM,






how will you remove the duplicate records from flat file without using sorter?

7 Answers  


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

0 Answers  


Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  


i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,


what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,


Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,


Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

6 Answers   CTS,


Categories