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
- 5219 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
Name the different types of Lookups in Datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What can we do with datastage director?
Name the command line functions to import and export the DS jobs?
How do you import and export data into datastage?
Name the third party tools that can be used in datastage?
What are the difference types of stages?
What are the types of jobs we have in datastage?
How can we improve performance of data stage jobs?
How can we improve the performance in datastage?
What are the different layers in the information server architecture?
What is apt_config in datastage?
How do you register plug-ins?
How do you reject records in a transformer?
