Answer / zer0

I think this might work for you .........

Use the following flow :

Source ---> SQ ---> Expression ---> Normalizer ---> Filter -
--> Target

In the expression use variable ports to form 3 columns
depending on the values received in Column2. I mean to say
the given value is X,Y,Z in column2 so create 3 ports and
eac port will have 1-1 values i.e. X then Y then Z.
For this use SUBSTR and INSTR functions.
SUBSTR to get the part of the string and INSTR to find the
position.

VARIABLE_PORT1 ---> substr(column2,1,1)

VARIABLE_PORT2 ---> IIF(instr(column2,',',1,1)!=0,substr
(column2,instr(column2,',',1,1)+1,1),NULL)

VARIABLE_PORT3 ---> IIF(instr(column2,',',1,2)!=0,substr
(column2,instr(column2,',',1,2)+1,1),NULL)


Direct the variable ports to 3 output ports and this output
ports will go to normalizer. In normalizer create 2 ports
Column1 and Column2 and put the number of occurances for
column2 as 3.

The output will be 2 ports from normalizer which will be
feed to filter. In filter, filter out the null values in
column2 if it exists (IIF(ISNULL(Column2),FALSE,TRUE)

Direct the output of filter to target.

Hope this works !!!!!!!!!!

Revert Back if it works

Answer / kondeti srinivas

HI Zer0 YOUR SOLUTION PERFECTLY WORKING GREAT BUDDY

Answer / j

Great!!!
It worked really well.
Thanks for the solution.

Is it possible to have "5 source & 5 Target" in single mapping?

1 Answers  

---

What is the functionality of update strategy?

2 Answers  

---

What are the associated ports in look up T/R.

5 Answers   IBM, Zensar,

---

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

---

Explain the types of lookup transformation?

0 Answers  

---

Where do you create/define mapping parameter and mapping variable?

1 Answers  

---

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

2 Answers  

---

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,

---

How can you complete unrcoverable sessions?

1 Answers  

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,

---

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

---

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,

---