1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / raja

Answers were Sorted based on User's Feedback



I am getting five sources in a day and i donot know when i get them. i need to load data into the ..

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

I am getting five sources in a day and i donot know when i get them. i need to load data into the ..

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

I am getting five sources in a day and i donot know when i get them. i need to load data into the ..

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 am getting five sources in a day and i donot know when i get them. i need to load data into the ..

Answer / dharmendra

I guess using event wait will keep the session in running
status.

Is This Answer Correct ?    0 Yes 0 No

I am getting five sources in a day and i donot know when i get them. i need to load data into the ..

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

I am getting five sources in a day and i donot know when i get them. i need to load data into the ..

Answer / bsgsr

gud answer rajsekhar.

wud you mind calling me on my num once 9866188658

Is This Answer Correct ?    0 Yes 11 No

Post New Answer

More Informatica Interview Questions

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

Which development components of informatica have the highest usage?

1 Answers  

write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers   TCS,

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,

Useful UNIX commands regular/frequently used

1 Answers   Deloitte,

Can you copy the batches?

3 Answers  

Differentiate between source qualifier and filter transformation?

1 Answers  

Is it possible to use a client with different version than that of its Informatica server?

1 Answers  

What is the difference Between Mapping parameter and variable

3 Answers   Accenture,

For more Informatica Interview Questions Click Here
Categories