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
- 8980 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinu
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 |
Post New Answer View All Answers
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What are the various kinds of the hash file?
What is the difference between hashfile and sequential file?
Name the command line functions to import and export the DS jobs?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What are the types of jobs we have in datastage?
What is oci?
How can we improve performance of data stage jobs?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What are the difference types of stages?
On which Dimension Table you implemented SCD Type in your Project
What is apt_config in datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
AGGREGATOR default datatype
