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

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

Explain what is informatica metadata and where is it stored?

Differentiate between reusable transformation and mapplet.

Explain the flow of data in Iinformatica?

What are the new features of informatica 9.x in developer level?

Why use shortcuts(Instead of making copies).

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

What are the different clients of powercenter?

How many repositories can we create in Informatica?

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

What is intricate mapping?

Categories