Hi ETL gurus can any one tell me with a flow how to
implement SCD Type 1 and SCD Type 2 in a single mapping.For
some fields SCD type has to be implemented and for some
fields scd type has to be implementd..Thank in
advance..please let me know in case of any concerns...
- 1 Answers
- 3559 Views
- I also Faced
- E-Mail Answers
Answer / hemanth
yes, u can see the out put in single run,
in mappings tab one option is there, that is TARGET LOAD
ORDER.
yes we can do scd type1 and scd type2 in a single mapping
itself when the source is same for both. But with same
source we will never face that situation if so the changes
in source will reflect both scd1 and scd2.
| Is This Answer Correct ? | 1 Yes | 0 No |
design of staging area?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Explain direct and indirect flat file loading (source file type) - informatica
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
how remove 1st 3 records & last 3 records in informatics
Explain scd type 3 through mapping.
How to delete duplicate records in a flat file source?
write a query for how to eliminate the duplicate rows without using distinct?
What is a difference between complete, stop and abort?
Can informatica load heterogeneous targets from heterogeneous sources?
Performance tuning in UNIX for informatica mappings?
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
Teradata 
