IICS | SCD TYPE 2 Using Lookup Effective Date Method| Slowly Changing Dim Typ 2 Informatica cloud

Hi Friends , in this example , we will learn how to implement SCD TYPE 2 with effective date approach using the lookup .
below are the DDL and data set you can use while practicing .
Source DDL and data
CREATE TABLE EMP
( "EMPNO" NUMBER(4,0),
"ENAME" VARCHAR2(10 BYTE),
"JOB" VARCHAR2(9 BYTE),
"SAL" NUMBER(7,2),
"COUNTRY" VARCHAR2(100 BYTE)
)
DATA :
Insert into EMP (EMPNO,ENAME,JOB,SAL,COUNTRY) values (7369,'SMITH','DEVELOPER',800,'UNITED KINGDOM');
Insert into EMP (EMPNO,ENAME,JOB,SAL,COUNTRY) values (7499,'ALLEN','SALESMAN',1600,'INDIA');
Insert into EMP (EMPNO,ENAME,JOB,SAL,COUNTRY) values (7521,'WARD','SALESMAN',1250,'UNITED KINGDOM');
target DDL
CREATE TABLE EMP_SCD2_EFF_DT
( "EMP_KEY" NUMBER(38,0) NOT NULL ENABLE,
"EMPNO" NUMBER(4,0) NOT NULL ENABLE,
"ENAME" VARCHAR2(10 BYTE),
"JOB" VARCHAR2(9 BYTE),
"SAL" NUMBER(7,2),
"COUNTRY" VARCHAR2(100 BYTE),
"EFF_DT" TIMESTAMP (6),
"END_DT" TIMESTAMP (6),
CONSTRAINT "EMP_SCD2_EFF_DT_PK" PRIMARY KEY ("EMP_KEY")
#informatica #iics #informática #tutorial #etltesting #datawarehouse #sql

[@nareshkumar-jl4ke]

good explanation watching from whitefiled bangalore working in one of the MNC companies

[@nireeshag198]

Excellent explanation sir. Thankyou so much!

[@talladasaisatishkumar2271]

Its very helpful thanks for uploading for these helpful videos please upload more videos bro , please upload joiner transformation instead of lookup

[@ETLSTATION]

its there in playlist already IICS | SCD TYPE 2 Without Lookup Effective Date Method in Informatica Cloud | Slowly Changing dim 2 kzbin.info/www/bejne/aKeynaCeobR3Y7c

[@gaddamnaresh5352]

Very useful and easy to understand... Thank you so much

[@ETLSTATION]

thank you for your feedback . i am glad that it was helpful . keep watching

[@hemantsonirbz]

Very Helpful, Thanks for doing this. Keep up the good work.😀

[@ETLSTATION]

thank you , watch all videos and share with friends, comment if any doubt

[@ajayaj470]

Excellent explanation bro 😍😍😍😍

[@ETLSTATION]

Thank you so much 🙂

[@juliburnwal9940]

Hi, the way of explaining strategy is too good, just a question in my mind why we are not using data driven functionality like dd_update, dd_insert here in target table to insert & update the records or we can use? if yes then how?

[@Sosa-t6j]

Best❤

[@KritinSinha]

I am not able to see 'Lookup Source Filter' in the advance tab in Lookup transformation. Is it something because of IICS UI being updated? has that option moved to somewhere else?

[@ETLSTATION]

i will check and let you know

[@sadafchannel5717]

Checksum without also can do it right?

[@ETLSTATION]

@@sadafchannel5717 md5 ? its checksum only , informatica uses md5 for checksum

[@anilkumarakc1046]

❤

[@ETLSTATION]

hope you liked video , watch it full and practice it . keep supporting

[@GoodMindGoodFind]

👌🏻👌🏻👌🏻😊😊

[@juliburnwal9940]

How to implement scd-2 by using dynamic lookup?

[@Mustaq15]

internal error. the dtm process terminated unexpectedly. contact informatica global customer support Facing problem

[@ETLSTATION]

did you follow exactly how i have made video ,

[@Mustaq15]

@@ETLSTATION followed exactly it is working correctly first time but after changes made new row is not get inserted

[@anubhavbanerjee776]

@@Mustaq15 i am also facing the same problem. my pipeline is running correctly first time but from the next time, no rows are getting processed