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
- 15209 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
What is complex mapping?
What is meant by target load plan?
What is rank transformation?
What is domain and gateway node?
How to elaborate powercenter integration service?
How many numbers of sessions can one group in batches?
How can you increase the performance in joiner transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to extract sap data using informatica?
Explain scd type 3 through mapping.
Explain informatica architecture - version 8 / 9
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
To import the flat file definition into the designer where should the flat file be placed?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What's the layout of parameter file (what does a parameter file contain?)?
