Interested to Buy Any Domain ? << Click Here >> for more details...
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
- 3 Answers
- 26100 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are some examples of informatica etl programs?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How to extract sap data using informatica? What is abap? What are idocs?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Explain joiner transformation in informatica
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Explain the informatica workflow?
Why union transformation is an active transformation?
What is union transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are the different ways to implement parallel processing in informatica?
How we can create indexes after completing the load process?
How to call shell scripts from informatica?
