Hey I am net to informatica? Can any one explain me step by
step How scd will work ?
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 |
After we make a folder shared can it be reversed?Why?
How do you migrate data from one environment to another?
what is bitmap index? did u use it?and how to use it in informatica
Kimball and Inmon methodologies?
What is the procedure for creating independent data marts from informatica 7.1?
What is the term PIPELINE in informatica ?
HOW TO DELETE A RECORD FROM FLAT FILE
can session assigned multiple mappings or not?
What is workflow monitor?
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
can we load the data with out a primary key of a table? what is target plan?
What is operational data source (ODS)?