Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 14966 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
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
update strategy transformation in informatica
What is union transformation in informatica?
Explain in detail scd type 2 through mapping.
What is the use of code page?
what is informatica metadata?
How can we use mapping variables in informatica? Where do we use them?
How to configure mapping in informatica?
Under what condition selecting sorted input in aggregator may fail the session?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How to update a particular record in target with out running whole workflow?
Does an informatica transformation support only aggregate expressions?
How do you take back up of repository?
What are the various types of transformation?
Explain the use of aggregator cache file?
Briefly describe lookup transformation?
