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
- 3130 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
Explain the etl program with few examples.
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
How do you load alternate records into different tables through mapping flow?
Differentiate between source qualifier and filter transformation?
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
How do you change parameter when you move it from development to production.
What is metadata reporter?
what is the method of error handling when session is running?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that
Teradata 
