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



How do we come to know the Source data/file is ready/Updated in the source location, when the sess..

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

How do we come to know the Source data/file is ready/Updated in the source location, when the sess..

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

Post New Answer

More Informatica Interview Questions

(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 Answers  


what is the process of target load planing?

2 Answers   IBM,


CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  


HOW TO YOU LOAD TIME DIMENSION

1 Answers  


write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers   TCS,






What are the modules in Power Center

0 Answers  


How to load relational source into file target?

3 Answers   IBM,


Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  


Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,


How do you do error handling in Informatica?

1 Answers  


Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  


what is data driven in informatica

5 Answers   IBM,


Categories