Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9365 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 |
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
What is hash partition?
What are the data movement modes in informatcia?
What are the mapings that we use for slowly changing dimension table?
How to load the data from a flat file into the target where the source flat file name changes daily?
what is the incremental agrrigation?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
what is the size of u r source(like file or table)?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
hi real timers . iam waiting for ur reply regarding ETL TESTING
can we import source table without using source qualifier? if yes then how? if no then why?
Teradata 
