Interested to Buy Any Domain ? << Click Here >> for more details...
Hey I am net to informatica? Can any one explain me step by
step How scd will work ?
- 1 Answers
- 7695 Views
- Infosys, I also Faced
- E-Mail Answers
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
How an expression transformation differs from aggregator transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Mention some types of transformation?
What is Index Caches size?
What are the data movement modes in informatica?
Define joiner transformation?
Define pmcmd command?
Explain incremental aggregation in informatica
Quickly characterize reusable change?
What is a node in Informatica?
Repository user profiles
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is flashback table ? Advance thanks
How to improve the performance of a session using sorter transformation?
