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 |
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
What are the uses of a Parameter file?
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
what is the command to get the list of files in a directory in unix?
what is the flat file partition and where have to specify it
What is primary and backup node?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the reusable transforamtions?
Hi All can anyone tell me where i will get Informatica training in Mumbai?
Define maping and sessions?