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 ..

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

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

Answer / rajesh bathini

seq---> Transformer------>
in transformer take one stageVariable
stg==> Alpha(C1) after transformer take two outputlinks
take constrain stg=0 for one link (number will go that link)
otherwise for one link(alphabets will go that link)

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 ..

Answer / leo gilbert

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 ..

Answer / bsgsr

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

Post New Answer



More Informatica Interview Questions

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?

1 Answers   Emphasis,


Explain what is informatica metadata and where is it stored?

0 Answers  


Differentiate between reusable transformation and mapplet.

0 Answers  


Explain the flow of data in Iinformatica?

1 Answers  


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

0 Answers  






Why use shortcuts(Instead of making copies).

1 Answers  


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

0 Answers   TCS,


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

0 Answers  


What are the different clients of powercenter?

0 Answers  


How many repositories can we create in Informatica?

3 Answers  


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.

10 Answers   IBM, Emirates,


What is intricate mapping?

0 Answers  






Categories