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
- 3760 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 |
Can you start a session inside a batch individually?
TELL ME ABOUT WORK FLOW SCHEDULING?
Describe two levels in which update strategy transformation sets?
how do u get the first record from 50,000 records ?
10 Answers TCS, UBS,
How do we implement materialized view?when to use materialized view?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
What is a test load?
How to read data from flat file source if the data is in paragraph format?
what are 3 tech challenges/ common issues you face?
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
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 anybady help me to achieve the aboue result by using informatica. thanks in advance.
scenario
Teradata 
