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.
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.
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
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.
Yes we have to pass default value to the variable
where we can use this logic like scd2 implementation?
Thanks for the great video
Thank you... keep watching
Thank you Sir 😊
You have created variable port where you can assign that variable port . I have confuse that step.
Refer again you will get it
Sir Can we perform incremental load if the date column is not present in source table?
Yes, We Can. We have other ways as well.
How to implement the same if source is sql server
Write SQL override and call the variable in sq query
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.
You can go as prod support
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
Sure will have another video with flat file