Hi Eswar, It works nicely.try once again

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

Question Posted / vijaya

9 Answers
16589 Views
Patni, I also Faced
E-Mail Answers

Answer Posted / vijaya

Hi Eswar,

It works nicely.try once again

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define repository tables in datastage?

1209

Name the third party tools that can be used in datastage?

1146

What are orabulk and bcp stages?

1165

What are the types of containers?

1315

What are the types of views in datastage director?

1828

What is the importance of the exception activity in datastage?

1116

what is use of SDR function?

5225

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1277

I have a few records just I want to store data in to targets cycling way how?

2418

How do you schedule or monitoring the job?

1271

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

2501

How to reverse the string using SQL?

1598

Can you explain tagbatch restructure operator?

1220

What are the main features of datastage?

1357

Can you explain how could anyone drop the index before loading the data in target in datastage?

1548