IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP
TRANSFORMATION ?

Answers were Sorted based on User's Feedback



IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?..

Answer / divi

Alternative to Lookup id Joiner.we need to import source
structure of target in Source Analyser and bring that into
mapping and use it for comparison like Lookup.

Is This Answer Correct ?    10 Yes 2 No

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?..

Answer / krishna

In the sesion u hav to put update else insert

Is This Answer Correct ?    7 Yes 1 No

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?..

Answer / shashiall

plz..use "update else insert" in the properties of session.

Is This Answer Correct ?    5 Yes 0 No

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?..

Answer / saritha

You can use Joiner transformation to design scd Type1
manually. Import target as source and use joiner
transformation. Use expression to insert and update the
rows into target.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  


in performance wise union is past,union all is past

2 Answers  


What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,


How you can differentiate between connected lookup and unconnected lookup?

0 Answers  


What is a surrogate key?

0 Answers  






What is informatica? Why do we need it?

0 Answers  


Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,


What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  


complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,


What is the default join that source qualifier provides?

3 Answers   Informatica,


What is native users?

0 Answers  


How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,


Categories