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

can we use mapplet as starting n ending object in mapping

2 Answers   TCS,

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,

Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  

how to we create datamart?

2 Answers   HSBC,

What is the use of code page?

0 Answers  




following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  

how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,

What is substr in informatica?

0 Answers  

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,

For more Informatica Interview Questions Click Here
Categories