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?
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
Why update strategy and union transformations are active?
What is workflow? What are the components of the workflow manager?
Differentiate between a repository server and a powerhouse?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Describe the impact of several join conditions and join order in a joiner transformation?
How can informatica be used for an organization?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What are multi-group transformations?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What do you mean by channel change?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What do mean by local and global repository?
How many transformations can be used in mapplets.
How can a transformation be made reusable?