I'd like the load to be triggered by client. By placement
of a file or somehow. How is it done in Informatica? I'm
using version 7.1.4
This is so urgent - I really appreciate your help :-)
Answers were Sorted based on User's Feedback
Answer / kiran
You can use a pmcmd command to trigger the workflow using a
shell script. You can also use the event wait task
described in the above answer.
Alternately you can use an UNIX script to work as an active
listener. This will trigger the workflow once the presence
of file is detected in a specific directory. A schedular
tool also will be useful.
If you could describe more about your requirement one can
add more thoughts into it.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / lakshmi
you could use an event wait task in the workflow as the
first task. Once the event wait task detects the file in
the specified folder all other sessions tasks wil run.
alternatively you could use unix commanda in the command
task.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / arnab
Add an event wait in your workflow and have a Unix script
touch a zero byte file in the source file directory and
configure the even wait to look for this zero byte file in
the source directory as soon as the event wait detects the
file the session will execute
| Is This Answer Correct ? | 1 Yes | 1 No |
how to sort date field in infomatica?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
without dynamic lookup how to insert new rows and update existing rows?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is decode in static cache?
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
What are the conditions needed to improve the performance of informatica aggregator transformation?
How will you combine 3 different sources with a single source?
What is a configuration management?
Why we need XMLs?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance