Answer Posted / 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

What is informatica metadata and where is it stored?

978

---

What is domain and gateway node?

1152

---

How to start a workflow using pmcmd command?

1223

---

Differentiate between source qualifier and filter transformation?

1561

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7414

---

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

952

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2148

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2503

---

What is a surrogate key?

1061

---

Explain the features of connected and unconnected lookup.

917

---

Clarify the aggregator change?

1012

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1937

---

What is a sorter transformation?

1078

---

What are the components of workflow manager?

1071

---

What is decode in static cache?

1151

---