Hey I am net to informatica? Can any one explain me step by
step How scd will work ?
Answer Posted / srinu
Selects all rows.
Caches the existing target as a lookup table.
Compares logical key columns in the source against
corresponding columns in the target lookup table.
Compares source columns against corresponding target
columns if key columns match.
Flags new rows and changed rows.
Creates two data flows: one for new rows, one for changed
rows.
Generates a primary key for new rows.
Inserts new rows to the target.
Updates changed rows in the target, overwriting existing
rows.
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
wf dont have integration severances how you can run?
What is an unconnected transformation?
What is the way to execute pl/sql script using informatica mapping?
Where is metadata stored?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is dynamic cache?
expain about the tune parameters?
How to elaborate tracing level?
Can we create two repositories on same database instance in oracle?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How do you load first and last records into target table?
Is there any target staging area in informatica not staging area
Can we create a Integration service without a Repository service and vice versa?
Explain why we use partitioning the session in informatica?