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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of olap? Give an example?

564


COM components can be used in Informatica

1876


EXL informatica Questions

938


What is a node in Informatica?

629


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

641






How can a transformation be made reusable?

665


Can we create multiple integration service on single repository?

703


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

812


What all are steps in up gradation of Informatica server?

622


what is the size of u r source(like file or table)?

1818


What is meant by a domain?

630


How to create a non-reusable instance of reusable transformations?

685


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1856


Explain the code page compatibility?

643


How to update source definition?

633