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
What is joiner change?
Define Pmrep command?
How to update source definition?
What are multi-group transformations?
What is informatica powercenter repository?
How we can use union transformation?
What is the sequence generator transformation in informatica?
What is dimensional table?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Partition, what happens if the specified key range is shorter and longer
How to Create a folder using pmrep command?
What is repository manager?
What is parallel processing in informatica?
What is the difference between informatica 7.0 and 8.0?