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
- 15044 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
How can one identify whether mapping is correct or not without connecting session?
What do you mean by blocking transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Explain the mapping variable usage example in informatica
What is decode in informatica?
Explain in detail about scd type 1 through mapping.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How to create or import flat file definition in to the warehouse designer?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Describe expression transformation?
explain abt ur project architecture?
I have a flat file, want to reverse the contents of the flat file
What is the different lookup cache(s)?
Briefly explain the aggregator transformation?
What will be the approach?
