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
- 8822 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 .ctl(control files) files ? how the dataset stage have better performance by this files?
Define oconv () and iconv () functions in datastage?
How a routine is called in datastage job?
Define Job control?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
client know skid info?
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?
How to perform incremental load in datastage?
Difference between in process and inter process?
What are the stages in datastage?
Differentiate between data file and descriptor file?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is the differentiate between data file and descriptor file?
How do you start developing a datastage project?
State the difference between an operational datastage and a data warehouse?
