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
- 5137 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain connectivity between datastage with datasources?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What are the functionalities of link partitioner?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How to convert RGB Value to Hexadecimal values in datastage?
Describe link sort?
In Datastage, how you can fix the truncated data error?
Can you define merge?
Explain the importance of surrogate key in data warehousing?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is the flow of loading data into fact & dimensional tables?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is aggtorec restructure operator?
How a server job can be converted to a parallel job?
