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 |
How many mapplets u have created? and what is the logic used
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
What is synonym?
why normalizer transformation can not used in mapplet? plzzzz answer
How to Join Tables my Source is having 15 table target is one?
how i will stop my workflow after 10 errors
Mapplets can you use an active transformation in a mapplet,
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
in realtime which situations u can use unconnected lookup transformation
i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0
Can we update the data in flat file using update strategy?
Major difference between SQL override and Lookup Sql override