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

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,


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

11 Answers   L&T,


how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,


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

5 Answers   IBM,


What is data merging, data cleansing and sampling?

6 Answers   Satyam,






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

1 Answers   Wipro,


what is threshold error in informatica?

1 Answers   TCS, Wipro,


what transformations are used for Variable port?

2 Answers  


what is SDLC way of code development?

0 Answers  


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

4 Answers  


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

2 Answers  


what is Partitioning ? where we can use Partition?

2 Answers   TCS, IBM,






Categories