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
- 14849 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
can we override a native sql query within informatica? Where do we do it?
What are the performance considerations when working with aggregator transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is meant by target load plan?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How to create or import flat file definition in to the warehouse designer?
Informatica Checkpoints
Target increases every day even though no new record was inserted
Describe expression transformation?
What is Data Caches size?
What are the new features of informatica 9.x developer?
Differentiate between joiner and lookup transformation?
What is workflow manager?
Which version configuration tool used in ur project?
