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
- 15032 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
Design time, run time. If you don't create parameter what will happen
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is the difference between stop and abort in informatica
What are the main issues while working with flat files as source and as targets ?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How can you validate all mappings in the repository simultaneously?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Briefly explain the aggregator transformation?
What are the new features of informatica 9.x at the developer level?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Have you worked with/created Parameter file
Did u used latest transformations of 8.6.0? for what?
What is an expression transformation in informatica?
tell me the rules and responsblites in our project(my project is development)
Explain how to import oracle sequence into informatica?
