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
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is the command line function to import and export the ds jobs?
How to read the length of word in unix?
What are the different kinds of views available in a datastage director?
What is the project in datastage?
how to abort the job its matain duplicates?
Can you filter data in hashed file?
What is the purpose of pivot stage and types of containers in datastage
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
table actions available in oracle connector?
whom do you report?
how to implement scd2 in datastage 7.5 with lookup stage
How do you reject records in a transformer?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are transforms and what is the differenece between routines and transforms?