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
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Name the different sorting methods in datastage.
What are the areas of application?
root tree will find which is server job and which is parallel job?
What is meta stage?
Difference between sequential file and data set?
how many rows sorted in sort stage by default in server jobs
Can you explain link buffering?
Name the third party tools that can be used in datastage?
How to manage date conversion in Datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the types of containers in datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
in oracle target stage when we use load option and when we use upsert option?
What are the types of jobs we have in datastage?