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 / 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 |
Post New Answer View All Answers
Difference between Data and Index Caches?
What is informatica worklet?
Define enterprise data warehousing?
What is the use of transformation?
how we can load rejected record's at run time?(not through bad files)
which one is better performance wise joiner or look up
How to call shell scripts from informatica?
Separate from an archive server and a powerhouse?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is decode in informatica?
In how many ways we can create ports?
my source is junk data how will u remove that junk data by using unix please any one replay me
Explain about cumulative Sum or moving sum?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?