Hi Guys,
I am trying below condition .
We are using Informatica 9.5 and scheduling certain informatica mapping on set timings .But we are not sure whether the database source table are latest or not .Since its gets updated on daily basis and not sure when it completes.Can we write any unix/perl script to access the database for those source systems. some logic to check counts/etc
and do certain checks based on which scheduling can be planned .
Also there are no source columns related to runday date for particular runs to identify latest data .
For ex: On july 12 --source should have 11th july data .
Please suggest some ideas if any perl or unix script be used
thanks