How do we come to know the Source data/file is
ready/Updated in the source location, when the session is
scheduled for @12:00AM and ready to run its job ? or Can we
schedule the session, when the source is updated in source
location without any time constraint?
Answers were Sorted based on User's Feedback
Answer / vinod
This may help for flat files.
this may be done using the event wait task.
1) upload the src file wiht a touch file.
2) schedule ur job at perticular time.
3) in wf use the event wait task.
4) event wait will wait for touch file, once it get the
touch file, it will start the load.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / dr
It all depends on the Organisation to Organisation which
uses different softwares (Control-M is one of them). The
job will be triggered based on the notification message
= 'Y' when the Source file is ready or else it will have a
status = 'N'.
| Is This Answer Correct ? | 4 Yes | 0 No |
How to handle decimal places while importing a flatfile into informatica?
which transformation uses cache?
What are the circumstances that infromatica server results an unreciverable session?
what is INFORMATICA TESTING process
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is the difference between Bitmap and Btree index?
What can we do to improve the performance of informatica aggregator transformation?
What are active transformations.
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
what is mean by grouping of condition column in lookup transformation?
Label in Informatica. How to remove existing Label.
hw cn v elimate dublicate values from lookup without overriding sql?