Answer / sbvprasad

by using normalizer T/r u can do the above logic

Answer / abhishek kumar(abhisheklalmca@

src->sq->normalizer->expression->target
In normalizer--
c1(column name)- 3(occurs)-string(datatype)

In Expression--

o_c1 -(output port)
decode(GCID_c1,1,'col1',2,'col2',3,'col3')

connect
o_c1(expression) to c1( target port)
c1(exp) to c2(target) port
target should be like this
C1 C2
---------- -----
col1 a
col2 b
col3 c


thanks
abhishek

Answer / ravi

USE NORMALIZER TRANSFORMATION

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

---

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers  

---

Explain what are the different versions of informatica?

0 Answers  

---

What are the issues you have faced in your project? How did you overcome those issues?

0 Answers   CTS, FEEE, TCS,

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

---

list out all the transformations which use cache?

0 Answers   Informatica,

---

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,

---

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers  

---

How can you join two tables without any common column present in them?

1 Answers   TCS,

---

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,

---

What is an expression transformation in informatica?

0 Answers  

---