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

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

What are datastage sequences?

670


Where do the datastage jobs get stored?

733


What are the features of datastage flow designer?

635


What is the different type of jobs in datastage?

574


8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

1784






Define project in datastage?

666


Differentiate between datastage and informatica?

727


Can you define merge?

668


How do you remove duplicate values in datastage?

632


What is ibm datastage?

606


In Datastage, how you can fix the truncated data error?

640


What are the different layers in the information server architecture?

643


What all are the different way to run a job?

642


What are the various kinds of the hash file?

664


What is difference between symmetric multiprocessing and massive parallel processing?

653