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 |
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
what is parameter file?
without using rank transformation how can we rank items by using some other transformations
What is the difference between writing a joiner query in ANSI style and THETA style?
How to configure mapping in informatica?
what are the output files that the informatica server creats during running a session?
How will you display "Mr" for male & "Mrs" for female in target table?
Which transformation should u need while using the cobol sources as source defintions?
How to compare Source and Target table, without using dynamic lookup?
What are the various types of transformation?
Design time, run time. If you don't create parameter what will happen