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
Differentiate between source qualifier and filter transformation?
Which files are created during the session rums by informatics server?
what is song in infrmatica...?
How to create the source and target database connections in server manager?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What does role playing dimension mean?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Explain what are the different versions of informatica?
What are some examples of informatica etl programs?
What are the components of workflow manager?
Can we create two repositories on same database instance in oracle?
r u done any partitions in ur project?
What is a sequence generator transformation?
How might one distinguish in the case of mapping is right or not without associating session?
What is the difference between STOP and ABORT options in Workflow Monitor?