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

Answers were Sorted based on User's Feedback

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now ..

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

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now ..

seq---> Transformer------>
in transformer take one stageVariable
stg==> Alpha(C1) after transformer take two outputlinks

 Is This Answer Correct ? 0 Yes 0 No

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now ..

Say your input is VAR1 which are a1 and 1a.

Have an expression transformation to create two more
variables VAR2 and VAR3 out of VAR1 using the SUBSTR
function.
VAR2 = SUBSTR(VAR1,1,1) and VAR3 = SUBSTR(VAR1,2,1).
For VAR1=a1, VAR2=a and VAR3=1
VAR1=1a, VAR2=1 and VAR3=a

Pass VAR2 and VAR3 to the router. Have one output group
with condition IS_NUMERIC(VAR2) and the other obviously is
the default group. For the first group connect VAR2 to ID
of target and VAR3 to NAME of target. For default connect
VAR2 to NAME and VAR3 to ID

Output
=====
ID NAME
= =====
1 a
1 a

 Is This Answer Correct ? 0 Yes 5 No

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now ..

hi, sri krishna

gud thinking,

cn i have ur mail id or contact number
my no 9866188658
bsrinivas1213@gmail.com

 Is This Answer Correct ? 0 Yes 5 No

HOW DO YOU PARFORM INCREMENTAL LAOD ?

in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

how many tasks are there in informatica ?

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

What is data merging, data cleansing and sampling?

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

what is threshold error in informatica?

what transformations are used for Variable port?

what is SDLC way of code development?

What are the basic needs to join two sources in a source qualifier?

What are the out put files that the informatica server creates during the session running?

what is Partitioning ? where we can use Partition?

Categories