Hi am sundar, i have datas like
00023-1010
00086-1010
00184F2-1010
.
.
.
.
SCH-AS-1010
200-0196-039
.
.
.
Now i want the result as values before the delimiter should
come under the column ITEM_CODE and values after the
delimiter should come under the column LOC_CODE.. But some
datas like "SCH-AS-1010", for this, "SCHAS" should come
under the column ITEM_CODE and 1010 should come under the
column LOC_CODE.. Pls help me..
Answer / kiran
hi this is kiran..,
u can do manipulate in transformer stage.in tranformer
stage some functions is ther like
FIELD('sring',delimeter,occurence.....) like that
A=Field('SCH-AS-1010','-',1)
B=Field('SCH-AS-1010','-',2)
C=Field('SCH-AS-1010','-',3)
then
concatenate A and B in ITEM_CODE C in LOC_CODE.
Is This Answer Correct ? | 7 Yes | 1 No |
Explain datastage architecture?
is it possible to access the same job by two users at a time in DataStage?
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
what is a force compile
1)How to Duplicate Records Delete in Sequential file?
how to sort two columns in single job in datastage.
Can you explain engine tier in information server?
What all are the different way to run a job?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How many types of stage?
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
What are some prerequisites for datastage?