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 |
Which is costliest transformation? costly means occupying more memory?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How you prepared reports for OLAP?
What is the use of incremental aggregation?
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
How do we implement materialized view?when to use materialized view?
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
what is the -ve test case in your project.
if i have a delimited file as source so how can we seperate this file into three diff targets?