I am getting five sources in a day and i donot know when i
get them. i need to load data into the target and run the
session. but here i can't keep the session in running or
can't stop the session. plz help me
Answers were Sorted based on User's Feedback
Answer / rajasekar c
You can use the "Event wait" task and trigger the workflow
whenever you get a particular file in a specified
location.Here the file name should be in a specific format.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / veeras
hi,
using EventWait we can load the data once we get the source.
Event wait 'll wait for the readiness of source data.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ankit kansal
Yes, of course event wait will keep the session in running state and as the question demands that the session should not kept in running state.
So, to overcome this situation one work around is to make a shell script which will wait for a file or a number of files in a folder ans as the status comes out to true then using
PMCMD command you can execute your session.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 1 Yes | 0 No |
I guess using event wait will keep the session in running
status.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ravi
i too think that event wait will keep the session in running
but the question is the session should not running
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bsgsr
gud answer rajsekhar.
wud you mind calling me on my num once 9866188658
| Is This Answer Correct ? | 0 Yes | 11 No |
Plz..let me know differences between Informatica 7.1 and 8.1?
why we use informatica in our project?
what is confirmed dimension?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
what is curr val use for in sequence generator?
Is it possible to have "5 source & 5 Target" in single mapping?
Explain one complecated mapping?
What is difference between a connected look up and unconnected look up?
Different sorts of metadata that stores in the storage facility?
if i am having 10 records in source, i want 20 records in target...how will you do it
Which transformation should we use to normalise the COBOL and relational sources?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?