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
- 9096 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 |
What are the measure objects?
What is A complex mapping?
What are the different components of powercenter?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
what are the row and column separations in Flat Files
What are junk dimensions?
how to connect two or more table with single source qualifier?
How do you implement scheduling in Informatica?
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Teradata 
