oracle stage--->surrogate key generator--->transformer the t/f hav

hi this is kiran
i have one table i want divide the table with two different
table like even rows and odd rows
how can i do this one
tell me plzz

Question Posted / eswar

4 Answers
8966 Views
I also Faced
E-Mail Answers

Answer Posted / eswar

oracle stage--->surrogate key generator--->transformer

the t/f having 'mod' function

mod(empkey,2)=0 --->even rows
mod(empkey,2)<>0 --->odd rows

empkey is generated from surrogate key generator

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1003

Which commands are used to import and export the datastage jobs?

1412

Differentiate between datastage and informatica?

1179

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2102

What is usage analysis in datastage?

1300

What are the important features of datastage?

1120

What are the difference types of stages?

1207

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1221

Can you explain kafka connector?

1303

Explain usage analysis in datastage?

1158

What are the different common services in datastage?

1278

What are the processing stages?

1096

What are the stages in datastage?

1081

Name the different types of Lookups in Datastage?

1251

what is the use of materialized view?

1564