Answer / robin

use scheman name as prefix in the table name in session
properties.

Answer / kritika

in the session we can give different connections based upon the database we want to load. In each table there will be different connection where we can give different database name

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

---

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  

---

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

---

i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?

3 Answers   IBM,

---

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

---

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  

---

what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,

---

what are the perameter and variable?

3 Answers   IBM,

---

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,

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---

checkout and checkin in informatica 8.6

3 Answers   TCS,

---