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
- 9109 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 is the different type of jobs in datastage?
Explain the situation where you have applied SCD in your project?
What are the areas of application?
Describe link sort?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Triggers,VIEW,Procedures
How many types of views are there in a datastage director?
Whats difference betweeen operational data stage (ods) and data warehouse?
How to Remove Duplicate using SQL?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Give an idea of system variables.
How and where you used hash file?
What are the partitioning techniques available in link partitioner?
How can one find bugs in job sequence?
Is the value of staging variable stored temporarily or permanently?
