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
- 14842 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
Under which circumstances, informatica server creates reject files?
Briefly describe lookup transformation?
What is data caches/ index caches?
How many dimensions are there in informatica?
How to generate sequence numbers using expression transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Enlist the advantages of informatica.
What are the differences between oltp and olap?
What is mapplet in informatica?
What is the difference between informatics 7x and 8x and what is latest version?
Describe an informatica powercenter?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Enterprise data warehouse your projects phase by phase explain?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
list out all the transformations which use cache?
