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
- 8983 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
Define ds designer?
Can you implement SCD2 using join, transformer and funnel stage?
What is the process of killing a job in datastage?
How do you generate sequence number in datastage?
How rejected rows are managed in datastage?
What could be a data source system?
How to find value from a column in a dataset?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What are the steps required to kill the job in Datastage?
Define meta stage?
What are data elements?
What are stage variables and constants?
Where the datastage stored his repository?
Explain ibm infosphere information server and highlight its main features?
What is usage analysis in datastage?
