can u apply SCD2 on flat file tgt? if yes wat is the procedure?
- 3 Answers
- 24310 Views
- Deloitte, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guddu kumar mehra
We can not update a record in a flat file as we need a Key column to update the record but in flat file we can not have a key column.
So we can not implement SCD type 2 on flat files.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / rajesh aitha
Yes, I can
Let’s go head implementation
Understanding: In SCD2 we have 3 steps
1. Identify new record and insert as new record
2. Identify Updates in target and insert it as new record
3. Update the updated records to makes end date as system date
Process of implementation:
Step1: Generate 3 files as described above
Step2: The file to update is available and we have surrogate key of each row as well , use a script to Fetch the surrogate key to separate temporary file, Delete these rows from main file and keep it as separate file with appended field Last updated date at extreme right side of the file
Step2: So here we have 2 new files created for with new records as inserts, 1 file with updates. Now keep adding these 3 files to the mail file one by one in sequence.
What do you think?
| Is This Answer Correct ? | 0 Yes | 8 No |
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How to run a session, which contains mapplet?
What is Datadriven?
What is the difference between procedure and stored procedur?
Explain pmcmd command usage in informatica
What is an expression transformation in informatica?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How do you update the records with or without using update strategy?
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
Teradata 
