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 / suresh

scd type 2

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the different kinds of facts.

562


What do you understand by term role-playing dimension?

572


Explain where to store informatica rejected data? How to extract the informatica rejected data?

578


What is the difference between informatica 7.0 and 8.0?

565


What is joiner change?

674






Explain transaction control transformation in informatica

761


How to partition the Session?

643


What is lookup change?

614


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1234


What is persistent lookup cache?

601


Explain the different dimensions.

550


What is the format of informatica objects in a repository?

598


While migrating the data from one environment to another environment how would you manage the connections?

623


What is a repository manager?

646


What do you mean by filter transformation?

551