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

can a port in expression transf be given the name DISTINCT

3 Answers  


What are reusable transformations in how many ways we can create them?

2 Answers  


explain about informatica server architecture?

1 Answers   IBM,


why we use materialized view over view?

1 Answers   Zensar,


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

0 Answers  






What are the types of groups in Router transformation?

1 Answers   Informatica,


What is the target load order?

3 Answers   HCL, Informatica,


What are variable ports and list two situations when they can be used?

1 Answers  


What is exclusive and normal mode for repository services?

0 Answers  


Differentiate between a repository server and a powerhouse?

0 Answers  


What is the Difference between PowerPlay transformer and power play reports?

1 Answers  


What are batches?

0 Answers  


Categories