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 / prasad
hi shiva and srinu, its not work properly, would u plz
explain how to write the condition.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are sequencers?
Is the value of staging variable stored temporarily or permanently?
What is the difference between account and directory options ?
Differentiate between datastage and informatica?
What is size of a transaction and an array means in a datastage?
What is difference between server jobs & parallel jobs?
What are the types of containers in datastage?
How to manage date conversion in Datastage?
What is the sortmerge collector?
what is ds administrator used for?
What is a datastage job?
What is a merge?
Nls stands for what in datastage?
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?
What is ibm datastage?