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 difference between a gateway node and worker node?
What are the limitations of joiner transformation?
How to handle decimal places while importing a flatfile into informatica?
Briefly describe lookup transformation?
what is index?how it can work in informatica
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How might one distinguish in the case of mapping is right or not without associating session?
According to his methodology what all you need before you build a datawarehouse
How to go to the older version for a mapping?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Enlist some properties of sessions.
To import the flat file definition into the designer where should the flat file be placed?
Clarify the utilization of aggregator cache record?
What are connected or unconnected transformations?
What is source qualifier transformation in informatica?