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
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
Define oconv () and iconv () functions in datastage?
What is the purpose of pivot stage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
what is the custome stage in datastage? how can we impliment that one? plz tell me
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?
What are the different type of jobs in 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
What is the sortmerge collector?
What is active and passive stage?
Define ds designer?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How a routine is called in datastage job?
Explain usage analysis in datastage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
how to export or import the jobs in .ISX file