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 |
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
Explain what transformation and how many are there in informatica?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
what is update strategy transformation ?
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
what is sql override?what is the use of it?
How to recover sessions in concurrent batches?
Explain sql transformation in script mode examples in informatica
what is fact table?
what is the method of error handling when session is running?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
comonly how meny mappings r there in Banking projects?