Hey I am net to informatica? Can any one explain me step by
step How scd will work ?
- 1 Answers
- 6828 Views
- Infosys, I also Faced
- E-Mail Answers
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 |
what is confirmed dimension?
What is standalone command task?
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
what are the different types of transformation available in informatica and what are the mostly used ?
how can run the wf through pmcmd commend? write script?
What is the sql query overwrite in source qualifier in informatica
What will be the approach?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
Define Incremental Aggregation?
How many ways are there to do 'remove duplicate records in informatica'?
Explain why we use partitioning the session in informatica?
what is the exact meaning of domain?
Teradata 
