Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3756 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
what are 3 tech challenges/ common issues you face?
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 many ways a relational source definition can be updated and what are they?
Explain constraint based loading in informatica
What are the tasks that source qualifier perform?
What is a sequence generator transformation?
Can we create two repositories on same database instance in oracle?
what is the -ve test case in your project.
What is the benefit of partitioning a session?
What are the differences between source qualifier and joiner transformation?
what is $$$$?
What are the advantages of informatica?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
How to use pmcmd utility command?
How does the aggregator transformation handle null values?
