can u apply SCD2 on flat file tgt? if yes wat is the procedure?
- 3 Answers
- 24275 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 |
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
How to import oracle sequence into Informatica?
how to get flatfile containg 10 records half records one target another half another target
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
Did u used latest transformations of 8.6.0? for what?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How we can confirm all mappings in the repository simultaneously?
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
What is the Difference between SetVariable and setmaxvariable in informatica?
How identifying bottlenecks in various components of informatica and resolving them?
Teradata 
