Answer / rahul

for n source we required n-1 joiner t/r.

ex: if we have 3 flat file dan we requried 2 joiner t/r

Could you explain what is enterprise data warehouse?

0 Answers  

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

---

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,

---

What does refresh system mean, and what are its distinctive choice?

0 Answers  

---

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,

---

what is the incremental agrrigation?

2 Answers   Cap Gemini,

---

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

How to import oracle sequence into Informatica?

3 Answers   Satyam,

---

how to get flatfile containg 10 records half records one target another half another target

2 Answers  

---

What are the join types in joiner transformation?

1 Answers   Informatica,

---