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
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,
Explain lookup transformation in informatica
what is the complex transformation you used in informatica
Briefly define a session task?
waht type of interface is used for testing the data in informatica
What is an expression transformation in informatica?
How many transformations can be used in mapplets.
Explain sql transformation in script mode examples in informatica
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
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.
What is the use of target designer?
how we can load rejected record's at run time?(not through bad files)
What is deployment group?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is mapping debugger?