can u apply SCD2 on flat file tgt? if yes wat is the procedure?
- 3 Answers
- 24364 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 |
tell me 5 session failure in real time how can you solve that in your project?
what is informatica metadata?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Explain the tuning lookup transformation - informatica
Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks
when will we go for unconnected lookup transformation in Informatica?
need for registering a repository server
What is meant by LDAP users?
server hot-ws270 is connect to Repository B. What does it mean?
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
What is synonym?
Teradata 
