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
- 9363 Views
- iFlex, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain the different lookup methods used in informatica?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is main use of mapplet?
How identifying bottlenecks in various components of informatica and resolving them?
What is target designer and target load order?
Define Pmrep command?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
write a query to retrieve the latest records from the table sorted by version(scd)
What are the different transaction levels available in transaction control transformation?
Name the different lookup cache(s)?
While migrating the data from one environment to another environment how would you manage the connections?
What is a node in Informatica?
What the difference is between a database, a data warehouse and a data mart?
How can repository reports be accessed without sql or other transformations?
