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
- 8971 Views
- I also Faced
- E-Mail Answers
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 |
which unix commands mostly used in datastage
What are the various kinds of the hash file?
What is ibm datastage?
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
Can you explain link buffering?
Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,
Have you have ever worked in unix environment and why it is useful in datastage?
Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.
What are the some differences between 7.x and 8.x version of datastage?
What is the command line function to import and export the ds jobs?
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Teradata 
