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 |
What does update strategy mean, and what are the different option of it?
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
wf dont have integration severances how you can run?
Explain the different dimensions.
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
can we generate reports in informatica ? How?
What are the differences between a connected lookup and unconnected lookup?
In ur current projectu have done any performance tuning of mappings?
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater