supose if ur scr table contains alphanumeric values like
1,2,3,a,v,c in one columen like c1 n now u have load d data
in 2 seperare columns like ID should contain only numbers
1,2,3 n NAME col should contain a,b,cin target?How

Answer Posted / sai krishna karri

Here you should not use a router as it sends the data to
two different target or two instances of the same target.

As the question here is to write the input row to to
different columns based on the value, you can just use an
expression, pass the column and create two output ports.
Output port 1 to detect if it is a numeric. And the second
output port to detect the alphabet.

output port 1 - op1
iif(is_numeric(to_int(c1)),c1)

output port 2 - op2
iif(is_alphabet(c1),c1)

Pass these two outputs to a filter and set ths condition

Not isnull(op1) or Not isnull(op2)

Link the columns to the target now. Done!

Is This Answer Correct ?    9 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6731


Explain lookup transformation in informatica

626


what is the complex transformation you used in informatica

2163


Briefly define a session task?

564


waht type of interface is used for testing the data in informatica

1808






What is an expression transformation in informatica?

492


How many transformations can be used in mapplets.

1429


Explain sql transformation in script mode examples in informatica

572


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1308


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1178


What is the use of target designer?

577


how we can load rejected record's at run time?(not through bad files)

1884


What is deployment group?

662


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

2117


What is mapping debugger?

547