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
- 5289 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 the situation where you have applied SCD in your project?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is ds designer?
what is repositery?
What is a quality stage in datastage tool?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How do you start developing a datastage project?
What is a folder? Difference types of stages?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What is the sortmerge collector?
What is job control?
Name the third party tools that can be used in datastage?
What are the job parameters?
