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
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
Does datastage support slowly changing dimensions ?
How do you register plug-ins?
What are the types of hashed files in data stage
Describe stream connector?
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?
Which warehouse using in your datawarehouse
How do y read Sequential file from job control?
What are the important features of datastage?
Explain entity, attribute and relationship in datastage?
What are the various kinds of containers available in datastage?
What is the difference between hashfile and sequential file?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
explain about citrix scheduling tool in datastage
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How to convert RGB Value to Hexadecimal values in datastage?