Answer / kiran

You can use a pmcmd command to trigger the workflow using a
shell script. You can also use the event wait task
described in the above answer.

Alternately you can use an UNIX script to work as an active
listener. This will trigger the workflow once the presence
of file is detected in a specific directory. A schedular
tool also will be useful.

If you could describe more about your requirement one can
add more thoughts into it.

Answer / lakshmi

you could use an event wait task in the workflow as the
first task. Once the event wait task detects the file in
the specified folder all other sessions tasks wil run.

alternatively you could use unix commanda in the command
task.

Answer / arnab

Add an event wait in your workflow and have a Unix script
touch a zero byte file in the source file directory and
configure the even wait to look for this zero byte file in
the source directory as soon as the event wait detects the
file the session will execute

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  

---

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  

---

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,

---

What is sql query override? When did u use sql query override?

1 Answers   TCS,

---

Scenario:-  Below is the requirement. Source:-  NAME          ID                    Requirement  RAVI            1                      (no need to repeat as it ID is 1) KUMAR        3                     (repeat 3 times as it ID is 3) John             4                     (repeat 4 times as it ID is 4) Required Out Put:- Name                   ID RAVI                     1                    KUMAR                3      KUMAR                3 KUMAR                3  John                     4 John                     4 John                     4 John                     4 Scenario 2:- Source Data  ID              NAME 1,2            NETEZZA,ORACLE 3,4,5         SQL Server, DB2, Teradata Required Output:-  ID                   NAME 1                  NETEZZA 1                  ORACLE 3                  SQL Server 3                  DB2 3                  Teradata

1 Answers   Cognizant,

---

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

---

Design a mapping to get year of join for each employee.

4 Answers   Accenture,

---

what is the size of your data warehousing?

0 Answers   IBM,

---

Do joiner transformation use cache? If so describe?

2 Answers   Patni,

---