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
- 5165 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 |
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
What is a folder? Difference types of stages?
What are the components of datastage?
if ename='subbu' while running job the job should be abort how come?
What a datastage macro?
Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?
15 Answers Scope International,
Why do you need stage variables?
How will you move hashed file from one location to another location?
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
Is there any possibility to generate alphanumeric surrogate key?
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
How you can fix the truncated data error in datastage?
Teradata 
