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

what happens if you try to create a shortcut to a non- shared folder?

1 Answers  

---

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

---

A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  

---

Explain what transformation and how many are there in informatica?

0 Answers  

---

Explain transaction control transformation in informatica

0 Answers   Informatica,

---

hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  

---

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,

---

What is domain and gateway node?

0 Answers  

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

0 Answers   TCS,

---

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

---

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

0 Answers  

---