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
- 13489 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Does an informatica transformation support only aggregate expressions?
What is the meaning of decode in informatica?
Define Pmrep command?
What is session task and command task?
What is a grid in Informatica?
Global and Local shortcuts. Advantages.
wat are deployement groups in informatica, how it will be used for developers
What is a passive transformation?
How would you copy the content of one repository to another repository?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Where are the source flat files kept before running the session?
What is the difference between router and filter?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Explain the difference between a data warehouse and a data mart?
Explain in detail about scd type 1 through mapping.
