Hi 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....
- 1 Answers
- 3131 Views
- I also Faced
- E-Mail Answers
Answer Posted / kiran ghatage
You will find this in following examples...
https://community.informatica.com/solutions/mapping_implementing_scd1_using_md5
https://community.informatica.com/solutions/mapping_scd_type_2_effective_date
https://community.informatica.com/solutions/mapping_scd_type_2_versioning
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do we call shell scripts from 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
How to improve the performance of a session using sorter transformation?
What are the designer tools for creating transformations?
What is fact table? Explain the different kinds of facts.
Explain target update override in informatica
How many numbers of sessions can one group in batches?
Enterprise data warehouse your projects phase by phase explain?
Define enterprise data warehousing?
What is meant by target load plan?
How big was your fact table
Explain informatica architecture - version 8 / 9
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Explain the difference between a data warehouse and a data mart?
In which transformation you cannot drag ports into it?
