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...
Answer Posted / madan
use substr in transformer and divide it in to 2 fields as
required
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we use target hash file as a lookup ?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Can you explain players in datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
How to clean the datastage repository?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are the different types of lookups in datastage?
What is the difference between odbc and drs stage?
Triggers,VIEW,Procedures
options available in sequence job to run,validate?
What are the various kinds of the hash file?
Why we use surrogate key?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What are the difference types of stages?