Interested to Buy Any Domain ? << Click Here >> for more details...
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..
- 1 Answers
- 5294 Views
- I also Faced
- E-Mail Answers
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 |
how can we create rank using datastage?what is the meaning of rank?
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
What are the types of containers in datastage?
What is the Difference Between DataStage 7.5 version and 8.1 Version?
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?
What is the use of hoursfromtime() function in transformer stage in datastage?
how to abort the job its matain duplicates?
what are the errors,warnings in datastage
How to convert table data into xml file using xml output stage? please explain step by step;
IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
Teradata 
