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
- 14848 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rajesh bathini
seq---> Transformer------>
in transformer take one stageVariable
stg==> Alpha(C1) after transformer take two outputlinks
take constrain stg=0 for one link (number will go that link)
otherwise for one link(alphabets will go that link)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / leo gilbert
Say your input is VAR1 which are a1 and 1a.
Have an expression transformation to create two more
variables VAR2 and VAR3 out of VAR1 using the SUBSTR
function.
VAR2 = SUBSTR(VAR1,1,1) and VAR3 = SUBSTR(VAR1,2,1).
For VAR1=a1, VAR2=a and VAR3=1
VAR1=1a, VAR2=1 and VAR3=a
Pass VAR2 and VAR3 to the router. Have one output group
with condition IS_NUMERIC(VAR2) and the other obviously is
the default group. For the first group connect VAR2 to ID
of target and VAR3 to NAME of target. For default connect
VAR2 to NAME and VAR3 to ID
Output
=====
ID NAME
= =====
1 a
1 a
| Is This Answer Correct ? | 0 Yes | 5 No |
Answer / bsgsr
hi, sri krishna
gud thinking,
cn i have ur mail id or contact number
my no 9866188658
bsrinivas1213@gmail.com
| Is This Answer Correct ? | 0 Yes | 5 No |
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
how i will stop my workflow after 10 errors
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
I have source like this 1:2;3. so i want to load the target as 123
What is the difference between lookup override and souce qualifier override ?
Reusable transformation and shortcut differences
How do you promote a non-reusable transformation to reusable transformation?
explain different types of modeling.
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
How to handle decimal places while importing a flatfile into informatica?
Teradata 
