Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 9113 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
Differentiate between odbc and drs stage?
Differentiate between operational datastage (ods) and data warehouse?
What are stage variables, derivations and constants?
Difference between server jobs & parallel jobs?
table actions available in oracle connector?
What is the difference between an operational datastage and a data warehouse?
How to clean the datastage repository?
What are the partitioning techniques available in link partitioner?
What is a merge in datastage?
how to sort two columns in single job in datastage.
how to abort the job its matain duplicates?
What are the types of views in datastage director?
How to RD using transformer?
Differentiate between validated and Compiled in the Datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
