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



I'd like the load to be triggered by client. By placement of a file or somehow. How is it don..

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

I'd like the load to be triggered by client. By placement of a file or somehow. How is it don..

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

I'd like the load to be triggered by client. By placement of a file or somehow. How is it don..

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



Post New Answer



More Informatica Interview Questions

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,


What is meant by active and passive transformation?

0 Answers  


what is inline view?

1 Answers   IBM,


Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,


what is confirmed dimension?

6 Answers  






Insert else update option in which situation we will use

4 Answers   HCL,


Major difference between SQL override and Lookup Sql override

0 Answers  


source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,


how to duplicates from expression transformation without using sorter before that

1 Answers  


Is it possible to use a client with different version than that of its Informatica server?

0 Answers  


What is different between informatica version 8 and 9 version

1 Answers   IBM, Cognizant,


What is informatica? What exactly are the practical uses in real world

2 Answers  






Categories