ok well vijay.ur quetion not proper k. see u can use s

Hi I have scenario like this

s/r table T/r table
ename,sal empno,ename,sal
vijay,2000 1 , vijay, 2000
kumar,3000 2 ,kumar , 3000
ravi ,4000 3 ,ravi , 4000

How can i get target table like that without using
Transformer stage?

Question Posted / kiran

8 Answers
13544 Views
Semantic Space, I also Faced
E-Mail Answers

Answer Posted / kiran

ok well vijay.ur quetion not proper k.

see u can use s_key,column genaretor stage.
and u can define user define query in source level and
populated to target like dbl click on source and set read
method is user deine and write query=select
rownum,ename,sal from emp(s/r table name).k

Thanks&Regards
kiran
9393363309

Is This Answer Correct ?

1 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What a datastage macro?

1066

What is a folder? Difference types of stages?

1182

Explain Quality stage?

1162

Difference between sequential file and data set?

1210

What is the difference between hashfile and sequential file?

1268

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1422

Describe routines in datastage? Enlist various types of routines.

1016

What is a merge in datastage?

1276

Explain datastage architecture?

1407

AGGREGATOR default datatype

1466

how do u catch bad rows from OCI stage? And what CLI stands for?

2804

How do you schedule or monitoring the job?

1213

in oracle target stage when we use load option and when we use upsert option?

2286

Have you used Unstructured data?

1328

Name the different types of Lookups in Datastage?

1268