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 |
Define ds designer?
client know skid info?
What is a merge?
Difference between data warehousing and olap?
what is factless fact table?
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project
I have 100 records how can I load at a time from the single time
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
How to find value from a column in a dataset?
can explain wt is the pool for file.
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?