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
- 7669 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 can you generate reports in informatica?
Explain the informatica workflow?
Mention some types of transformation?
What are the types of caches in lookup? Explain them.
Define mapplet?
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?
What is informatica? Why do we need it?
Difference between Data and Index Caches?
What is decode in static cache?
What are the different types of olap? Give an example?
Is stop and abort are same in informatica?
How to open an older version of an object in the workspace?
Whats the difference between informatica powercenter server, repositoryserver and repository?
write a query to retrieve the latest records from the table sorted by version(scd)
How to handle decimal places while importing a flatfile into informatica?
