Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is the use of datastage director?

976


What is the difference between datastage and datastage tx?

1010


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)

869


What is active and passive stage?

1363


What are the different layers in the information server architecture?

1080


What are the different types of lookups in datastage?

1006


What are the types of hashed files in data stage

1061


How will you move hashed file from one location to another location?

2099


How do y read Sequential file from job control?

15807


What are the components of datastage?

1067


What is a ds designer?

1026


How many types of stage?

1135


What is datastage engine?

1126


Can you implement SCD2 using join, transformer and funnel stage?

1502


What are some different alternative commands associated with "dsjob"?

1084