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?
- 2 Answers
- 8689 Views
- iFlex, TCS, I also Faced
- E-Mail Answers
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 merge First Name & Last Name?
tell me 5 session failure in real time how can you solve that in your project?
when we go for unconnected lookup transformation? and why?
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
Can we create multiple integration service on single repository?
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
Performance tuning( what you did in performance tuning)
What are the components of workflow manager?
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
What is an Integration service in Informatica?
Teradata 
