Hi am sundar, i have datas like
00023-1010
00086-1010
00184F2-1010
.
.
.
.
SCH-AS-1010
200-0196-039
.
.
.
Now i want the result "SCH-AS" in onee column and "1010" in
another column.. Can any one tell the answer...
- 5 Answers
- 7595 Views
- I also Faced
- E-Mail Answers
Answer Posted / balu
We are using LEFT and RIGHT TRIM function in transform stage.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between datastage and datastage tx?
which r the connectors used in san?
Explain the importance of surrogate key in data warehousing?
What are the different types of lookups in datastage?
what is the use of surogate key in datastage
Is it possible to query a hash file?
What is the different type of jobs in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
what is the difference between == and eq in UNIX shell scripting?
What is ibm datastage flow designer?
Define data aggregation?
What is the difference between server job and parallel jobs?
Differentiate between datastage and informatica?
What is process model?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
