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...
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 |
How can you validate all mappings in the repository simultaneously?
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
How can we integrate different flat file data in a single mapping and with in a single execution
How can we handle two sessions in informatica?
How to elaborate powercenter integration service?
How to send duplicates to one target and unique rows to one target?target is empty
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
who is the best faculty for informatica in hyderabad ameerpet?
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
What is the way to execute pl/sql script using informatica mapping?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?