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?
Answer Posted / 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 |
Post New Answer View All Answers
What do you mean by worklet?
What are the various types of transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are the differences between a connected lookup and unconnected lookup?
What are mapplets?
How to load a Dimension ? and how to load a fact table?
Which are the different editions of informatica powercenter that are available?
Repository user profiles
What is an aggregator transformation?
What are batches?
How are the sources and targets definitions imported in informatica designer?
How to do the error handling of if ur source is flatfiles?
what is song in infrmatica...?
Reusable transformation and shortcut differences