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
Answers were Sorted based on User's Feedback
Answer / eswar
oracle stage--->surrogate key generator--->transformer
the t/f having 'mod' function
mod(empkey,2)=0 --->even rows
mod(empkey,2)<>0 --->odd rows
empkey is generated from surrogate key generator
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / farzana kalluri
Hi we can achive like this
Source--->Transformer---->filter--->2 targets
Transformer--->1.constraints--->mod(input,2)=0
2.constraint---->mod(input,2)=1
From this we can get the odd numbers in one target and
even numbers in one target...
Is This Answer Correct ? | 2 Yes | 0 No |
sourc->transformer->filter->two targets
in the transformer stage we have append new column and
derviation area write mod(@outrownum,2) (where @outrownum in
sysvarible)
after that we put fileter or switch in that
write condition on append column 0 then even records
1 then go odd records
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
what is the difference between the active datawarehouse and datawarehouse
what is the Difference Between Datastage Server Edition and Parallel Edition?
WHAT are unix quentios in datastage
What are transforms and what is the differenece between routines and transforms?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?
What is the difference between an operational datastage and a data warehouse?
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
How to convert table data into xml file using xml output stage? please explain step by step;
Describe the main features of datastage?
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?
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?