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
- 8931 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
options available in sequence job to run,validate?
How many types of sorting methods are available in datastage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
how to add a new records into source?
Is the value of staging variable stored temporarily or permanently?
how to write server Routine coding?
How do you reject records in a transformer?
What are the functionalities of link collector?
root tree will find which is server job and which is parallel job?
Define Data Stage?
What is the difference between an operational datastage and a data warehouse?
What is the flow of loading data into fact & dimensional tables?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How do you register plug-ins?
Define APT_CONFIG in Datastage?
