Hi Roshan, I am following your videos, which are really good. I need a video on when we don't have unique business key in target table(just like person address table, when a single person he has multiple address), need to implement scd Type2 transformation in iics, how can I do that, please suggest. Thanks in advance
@@ETLSTATION first time update performed fine, 2nd time update the record it shows both records are in active FLAG =Y for both update and upsert records
@@ETLSTATION in video you tried without lookup but i tried with lookup and i tried without lookup no issue it works perfectly but the only thing i use lookup i face the issue.
@@kirank-z6o watch with lookup video and see where you doing mistake , it must be column mapping to target , you may be mapping different column , watch my scd typ 2 with lookup video
Hi roshan i followed your videos in scdtype 2 with flag i have run the mapping task but i am getting error see the below "Internal error. The DTM process terminated unexpectedly. Contact Informatica Global Customer Support." please guide me
Hi Roshan, I am following your videos, which are really good. I need a video on when we don't have unique business key in target table(just like person address table, when a single person he has multiple address), need to implement scd Type2 transformation in iics, how can I do that, please suggest. Thanks in advance
Handling Deletes in SCD Type 2
hi mandender your question is not clear . what to you mean by handling delete in scd2 . please provide whole scenario
@@ETLSTATION how can we capture the source deleted records in SCD type_2?
How can we identify source deleted records and how can We soft delete those records?
Hi Roshan, your videos are really good. Could you please create more videos on real time project explanations and interview questions
yes , videos will keep coming , meanwhile watch all videos in playlist and all interview videos in playlist, there are many scenarios inside videos
when i tried this with_lookup first time i update the record flag change again i update the same record it shows both active and inactive flag is 'Y'
i did not get question , kindly provide with example what is issue
@@ETLSTATION first time update performed fine, 2nd time update the record it shows both records are in active FLAG =Y for both update and upsert records
@@kirank-z6o what my video shows , have you followed exactly as i have done
@@ETLSTATION in video you tried without lookup but i tried with lookup and i tried without lookup no issue it works perfectly but the only thing i use lookup i face the issue.
@@kirank-z6o watch with lookup video and see where you doing mistake , it must be column mapping to target , you may be mapping different column , watch my scd typ 2 with lookup video
Hi roshan i followed your videos in scdtype 2 with flag i have run the mapping task but i am getting error see the below "Internal error. The DTM process terminated unexpectedly. Contact Informatica Global Customer Support." please guide me