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
- 8796 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
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Explain datastage architecture?
Terminate Activity
Lookup constraints
What is use Array size in datastage
What is orabulk stage?
Why do we use link partitioner and link collector in datastage?
How the ipc stage work?
How to manage date conversion in Datastage?
What are the types of jobs we have in datastage?
How a server job can be converted to a parallel job?
Can you explain players in datastage?
What is difference between server jobs & parallel jobs?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
