Answer / smarati

It is active transformation because,

- we can do sql override
- select distinct option, which reduces the number of rows.
- we can use join condition

All the above increases/decreases the number of rows, so SQ
is active.

Thanks
Som

Answer / sushma

SQ transofrmation reads the rows from the source. It is an
active transformation.

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

---

What is workflow? What are the components of the workflow manager?

0 Answers  

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

0 Answers   HP,

---

How the informatica server increases the session performance through partitioning the source?

1 Answers  

---

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 DO YOU CONNECT TO REMOTE SERVER ?

1 Answers   Patni, TCS,

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,

---

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,

---

What is synonym?

2 Answers   Patni,

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,

---

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  

---