CDC/Incremental Load/Delta Load in Informatica

[@hasinikate3559]

One question, what value does the variable hold in first run..It is being set to maximum value of hired date rt? Then in first run how come all records getting loaded to.

[@sureshetltrainer]

Yes we have to pass default value to the variable

[@junedkhan-ge5mi]

where we can use this logic like scd2 implementation?

[@1112electronics]

Thanks for the great video

[@sureshetltrainer]

Thank you... keep watching

[@prajuyaragorla8161]

You have created variable port where you can assign that variable port . I have confuse that step.

[@sureshetltrainer]

Refer again you will get it

[@qlqa8932]

Sir Can we perform incremental load if the date column is not present in source table?

[@sureshetltrainer]

Yes, We Can. We have other ways as well.

[@meenuvinod7007]

Thank you Sir 😊

[@sakshikale9447]

How to implement the same if source is sql server

[@sureshetltrainer]

Write SQL override and call the variable in sq query

[@malateshreddy9122]

Hello sir, I am working in informatica power center and IICS monitoring team, like monitoring the jobs plz could u tell me like how to build my career.

[@sureshetltrainer]

You can go as prod support

[@pritamdey242]

Sir, please explain the filer logic for flat file source, getting datatype mismatch error, var datatype is date, source date column is of date datatype , in filter hire_date > to_date($$var,'MM-DD-YYYY HH24:MI:SS') is not working, if you could please add this part in next video it will be very helpful

[@sureshetltrainer]

Sure will have another video with flat file