Incremental load in informatica using mapping variable by manish

Incremental load logic using mapping variable.

[indrajitsen]

This is not complete CDC .... but this is CDC from the source side where we assume two features

1. Once a department is created it cannot be changed
2. Dept_no in Source is set as Increment only.

Nice simple explanations.

[MrVivekc]

hello manish, thanks for the explanation. current video scenario is related to incremental changes, please share the CDC scenario of updation of records.

[ManishSingh]

i am using variable in source qualifier to get only latest record, mapping variable you can use in the next run also it will keep the last max record in the repository

[Adikes_InfoTech]

Thank you for the good explanation. I have a question like if some records are deleted permanently from source and how can we identify those and remove from the target table as well in incremental load?

[mkr]

What if the existing record is updated for deptno 30 ... does this solves the problem . Only insertion of new records no updation . Only insertion that too new deptno > existing record ... not a good solution for cdc

[Indian_working_mom]

Hi manish, I have one doubt Informatica having automation option or not

[maheshaddagulla]

Thank You Manish, Very nice explanation.

[uditmittal]

Good for delta load.... But for updated source records and also for new records can we make comparison between the last updated date column in a source table with the mapping date variable in informatica??? And also can we refresh persistent cache without deleting that cache file or is there any option for refreshing persistent cache???  Looking forward for Thanks

[ctanuboddi]

Good Job Manish. This was just the inserts based on the dept no. Can you upload the updated and deletes and inserts too in the same mapping. Thanks

[ramraju]

thanks allot, good explanation, more helpfull

[lalamaheshkumar]

why you have defined the variable in expression transformation and assigned the max of the deptno using sexMaxVariable . what is the necessity . Are you using any where this variable v_max_dept_no_to_variable

[yogkutty]

What will happen if Informatica is shutdown ? Will the Mapping Variable be intialized to null ?

[natashashukla]

Hi Manish Have you uploaded ur other videos realted to CDC update somewhere else?if yes please share those path?

[atsec]

We can also do this using Look up - SCD 1 functionality, correct?

[kirannikil]

Very Nice explanation, could you share the CDC Delta + update video will help me.

[vasubonam]

Good work, i think current logic holds good only for delta (new records), but it wont work for CDC( updated source records)

[dhardl]

Good logic..But it captures only the Inserts..But CDC includes UPDATE also...That cannot be accomplished using this...can we do the update using mapping parameter? 

[hasnaindwhbi]

Can you please show me the implementation of CDC Transformation(flexible target key transformation)