How can u insert o ne row in the target if that row does not
exists in the target and update if it exists

Answer Posted / sujana

by using scd type2 v can do dis

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we create index after completion of load process?

596


What do think which one is the better joiner or look up?

724


draw informatica architecture 8.6 ?

3468


Please let me know how to make encryption and decryption with example?

1464


What is different between the data warehouse and data mart?

630






can u any challenge your project?

1602


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1515


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

1717


In which transformation you cannot drag ports into it?

776


Difference between Target-based loading and constraint-based loading?

550


What is the status code in stored procedure transformation?

683


How can we use mapping variables in informatica? Where do we use them?

616


What are different types of transformations available in informatica?

582


Repository user profiles

1375


Explain scd type 3 through mapping.

578