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
why do u need the IOS upgradation in a FC switch
Describe stream connector?
How to reverse the string using SQL?
client know skid info?
Name the different types of Lookups in Datastage?
What is "fatal error/rdbms code 3996" error?
how many rows sorted in sort stage by default in server jobs
How a source file is populated?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Whats difference betweeen operational data stage (ods) and data warehouse?
What are the types of containers?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are sequencers?
Differentiate between Join, Merge and Lookup stage?
How to read multiple files using a single datastage job if files have the same metadata?