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
- 5187 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
What is the difference between orabulk and bcp stages?
What all the types of jobs you developed?
What is meta stage?
What is datastage engine?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
State the difference between an operational datastage and a data warehouse?
What is the difference between Datastage 7.5 and 7.0?
what is the difference between == and eq in UNIX shell scripting?
What is the difference between account and directory options ?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
How do y read Sequential file from job control?
Can you define merge?
What are routines in datastage? Enlist various types of routines.
how to abort the job its matain duplicates?
