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
- 7496 Views
- I also Faced
- E-Mail Answers
Answer Posted / nish
You could also go for a column generator and cycle the values 1,0.
then filter based on this column.
It will be much faster then employing a transformer stage having to generate @rownum and then do a mod calculation.
Trying to reduce the number of transformer stages is a key efficiency best practice.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the benefits of datastage?
What are the difference types of stages?
What is the difference between account and directory options ?
how many rows sorted in sort stage by default in server jobs
What are the primary usages of datastage tool?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What are iconv and oconv?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
what is the difference between == and eq in UNIX shell scripting?
Which commands are used to import and export the datastage jobs?
What is the purpose of pivot stage and types of containers in datastage
What is a folder? Difference types of stages?
How do you reject records in a transformer?
What is the difference between odbc and drs stage?
what is the use of materialized view?
