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
- 9258 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 |
What is flashback table ? Advance thanks
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Useful UNIX commands regular/frequently used
What are active and passive transformations?
What are mapplets? How is it different from a Reusable Transformation?
What is complex mapping?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
When we are using Dynamic Cache,which options we will select in session level?
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
What are the components of Informatica? And what is the purpose of each?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
Teradata 
