in Technology by

 Explain in detail about SCD TYPE 1 through mapping.

1 Answer

0 votes
by

SCD Type1 Mapping

The SCD Type 1 methodology overwrites old data with new data, and therefore does not need to track historical data.

  1. Here is the source.
    SCD-Type-1-informatica-interview-questions
  2. We will compare the historical data based on key column CUSTOMER_ID.
  3. This is the entire mapping:
    Entire-mapping-informatica-interview-questions
  4. Connect lookup to source. In Lookup fetch the data from target table and send only CUSTOMER_ID port from source to lookup.
    Lookup-informatica-interview-questions
  5. Give the lookup condition like this:
    Lookup-condition-informatica-interview-questions
  6. Then, send rest of the columns from source to one router transformation.
    Router-transformation-informatica-interview-questions
  7. In router create two groups and give condition like this:
    Create-groups-informatica-interview-questions
  8. For new records we have to generate new customer_id. For that, take a sequence generator and connect the next column to expression. New_rec group from router connect to target1 (Bring two instances of target to mapping, one for new rec and other for old rec). Then connect next_val from expression to customer_id column of target.
    CustomerID-informatica-interview-questions
  9. Change_rec group of router bring to one update strategy and give the condition like this:
    Update-strategy-informatica-interview-questionsCondition-informatica-interview-questions
  10. Instead of 1 you can give dd_update in update-strategy and then connect to target.

Related questions

0 votes
    Explain in detail SCD TYPE 2 through mapping....
asked Mar 29, 2021 in Technology by JackTerrance
0 votes
    Explain SCD TYPE 3 through mapping....
asked Mar 29, 2021 in Technology by JackTerrance
0 votes
    I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow....
asked Mar 28, 2021 by JackTerrance
0 votes
    I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow....
asked Mar 28, 2021 by JackTerrance
0 votes
    answer the following. 1.explain all the parts of the computer in detail 2.explain the fundamental component of ... types of computer. Select the correct answer from above options...
asked Dec 31, 2021 in Education by JackTerrance
0 votes
    How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows...
asked Mar 28, 2021 in Technology by JackTerrance
0 votes
    How do you load only null records into target? Explain through mapping flow....
asked Mar 28, 2021 in Technology by JackTerrance
0 votes
    I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow....
asked Mar 28, 2021 in Technology by JackTerrance
0 votes
    I have been doing Java development for a long time, but I am ashamed to say I still don't have ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 7, 2022 in Education by JackTerrance
0 votes
    What is a confusion matrix? Explain in detail with the help of an example. Select the correct answer from above options...
asked Nov 12, 2021 in Education by JackTerrance
0 votes
    Explain in detail the inter-relationship between the food chain and food web. Select the correct ... Science proposed by,electromagnetic theory engineering physics,Science nptel...
asked Nov 7, 2021 in Education by JackTerrance
0 votes
    How do you load alternate records into different tables through mapping flow?...
asked Mar 28, 2021 in Technology by JackTerrance
...