Interested to Buy Any Domain ? << Click Here >> for more details...
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 :-)
- 3 Answers
- 8934 Views
- Alcatel-Lucent, ECI Telecom, I also Faced
- E-Mail Answers
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 |
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.
how to declare array in plsql?
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
What exactly mentioned in High level design document.can somebody explain me sequentialy.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
In session log thier should not be a single error how will u do
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
task is running successfully but data is not loded why?
What is the capacity of power cube?
Explain the different kinds of facts.
how to return multiple columes through through un-connect lookup?
Teradata 
