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 is the difference between Active and Passive transformation?
What is a node in Informatica?
can we override a native sql query within informatica? How do we do it?
What are mapplets? How is it different from a Reusable Transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is the meaning of up gradation of repository?
How does a sorter cache works?
How an expression transformation differs from aggregator transformation?
Mention few advantages of router transformation over filter transformation.
Explain the pipeline partition with real time example?
What are ETL Tools?
Briefly explain the aggregator transformation?
Separate from an archive server and a powerhouse?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What are the main issues while working with flat files as source and as targets ?