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
- 3229 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 |
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
If you want to create indexes after the load process which transformation you choose?
What is a code page?
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
can anyone explain me about retail domain project in informatica?
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
Separate from a database, an information bazaar, and an information stockroom?
What is Target Update Override? What is the Use ?
Define filter transformation?
What is target designer and target load order?
what is bridge tables in informatica
Teradata 
