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 |
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
my source is junk data how will u remove that junk data by using unix please any one replay me
What are the limitations of joiner transformation?
Where can we find the throughput option in informatica?
Write the prerequisite tasks to achieve the session partition?
What is IQD file?
What do you understand by term role-playing dimension?
Design a mapping to get year of join for each employee.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
what is the architecture of any Data warehousing project?