col1
123
abc
234
def
jkl
768
opq
567
789
but i want two targetss target1 contains only numeric values
and target2 contains only alphabet values like
trg1
123
234
768
567
789
trg2
abc
def
jkl
opq
Answer Posted / eswar
this is not working plz explain clearly
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of datastage director?
What is the difference between datastage and datastage tx?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is active and passive stage?
What are the different layers in the information server architecture?
What are the different types of lookups in datastage?
What are the types of hashed files in data stage
How will you move hashed file from one location to another location?
How do y read Sequential file from job control?
What are the components of datastage?
What is a ds designer?
How many types of stage?
What is datastage engine?
Can you implement SCD2 using join, transformer and funnel stage?
What are some different alternative commands associated with "dsjob"?