Answer / koti

by using expression transformation U can apply decode
function..

Answer / abhishek kumar

src->sq->exp->filter->tgt
expression t/f

flag ->
iif(gender='male','female','male')



abhishek guddu

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,

---

What is the difference between a connected look up and unconnected lookup?

0 Answers  

---

What is hash partition?

1 Answers  

---

What is union transformation in informatica?

0 Answers  

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   IBM, Infotech,

---

,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

3 Answers   Emphasis,

---

what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  

---

Write the unconnected lookup syntax and how to return more than one column.

0 Answers  

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?

3 Answers   CTS, Wipro,

---

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

---

What are the data movement modes in informatcia?

1 Answers  

---