top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to get the latest data in SCD?

+1 vote
81 views
How to get the latest data in SCD?
posted Jul 14, 2015 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

IN THREE WAYS WE CAN GET THE LATEST RECORD IN SCD ...

1)IN "SCD TYPE 2 TIME STAMP" FOR LATEST RECORD THE "END
DATE" FIELD WILL BE BLANK. THAT MEANS IT IS THE NEW ROW .

2)IN "SCD TYPE 2 FLAG " THE FLAG NUMBER OF THE NEW ROW WILL
BE ONE .

3) IN " SCD TYPE 2 VERSION " THE LATEST RECORD IS HAVING
THE MAXIMUM VERSION NUMBER .

answer Jul 16, 2015 by Manikandan J
Similar Questions
+2 votes

I have 2 source tables:

table A: table B:

A_id || A_code           B_id || B_code 
-----  -------           -----  ------- 
2          t2            1      t1
3          t3            2      t2
4          t4            3      t3 

I want to join 2 table use Slowly change dimension

target table:

tgt_id || tgt_code || is_table A || is_table B
-----  ------------   -----------   ----------- 
1          t1         0              x 
2          t2         x              x   
3          t3         x              x
4          t4         x              0

I can't check type 'is_table A ' and 'is_table B' when join table.

0 votes

Can anyone of you please elaborate on how to map the informatica for the inserts and updates to the target from source table?

I appreciate it, if you explain with example.

0 votes

I have 20 records in a file and I don't need the first and the last line, I need data from 2 through 19 lines only.
How can I achieve this?

+1 vote

I have look up T/F in the mapping. If the look up t/f fails to return a row based on the look up condition, i need to send the source record to Bad file. How can i do that?

0 votes

I need to show the latest Status based on 2 attributes (LAST_UPDATE and STAUS)
How can I do it in informatica? the source is flat file

Example:

NUMBER --------------------LAST_UPDATE ----------------- STATUS  
-----1 -----------------------01/26/2015  ----------------------   CREATED                  
-----1 ----------------------   01/27/2015  ------------------UNDER_PROCCESS                           
-----1----------------------    01/28/2015  ---------------------COMPLETED  
 -----2---------------------- 01/28/2015 ------------------ CREATED  
-----3---------------------- 01/28/2015 --------------------- UNDER_PROCCESS

Result should be

NUMBER --------------------LAST_UPDATE ------------- STATUS  ---------------LAST_STAUS  
-----1 -----------------------01/26/2015  ----------------------   CREATED -----------COMPLETED                 
-----1 ----------------------   01/27/2015  -----------------UNDER_PROCCESS ---- COMPLETED                           
-----1----------------------    01/28/2015  ---------------------COMPLETED ----------COMPLETED  
 -----2---------------------- 01/28/2015 ------------------ CREATED  ---------------- CREATED  
-----3---------------------- 01/28/2015 -------------UNDER_PROCCESS --UNDER_PROCCESS   
...