I have the following columns in the EMP table
Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981)
Desing a job such that the output contains the following
empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
I have a source table with column name CITY having 100
I want target table with column name start with 'A'
and 'B',remaining columns as reject outputs.
how can achieve this by data stage?please help me?????
I have a input data like,
And i want my output data like
class_id Marks Rank
101 50 2
101 60 1
101 40 3
102 90 1
102 35 2
how to do this in datastage?
what are the different type of errors in datastage?
1)s.key generate 1 to 700 records today. tomorrow another
400 will updated how to update the records using s.key
2)source is like :--
DB --> T/F stage1 --> seq1file
T/f 1 is linking with T/F2 ---> seq 2 how to load the data?
in source i given some conditions those r going in seq1.
The another data will going to seq2 how to do this ?
how can we create rank using datastage?what is the meaning of
what are the devoleper roles in real time? plz tell i am new
how to read 100 records at a time in source
a) hw is it fr metadata Same and
b) if metadata is nt same?
Can you filter data in hashed file?
I have a few records just I want to store data in to targets
cycling way how?
what is the use of surogate key in datastage
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
what is use of Macros,functions and Routines..?
At what situation you are used.
If you know the answer please explain it.
how to write server Routine coding?
what are .ctl(control files) files ? how the dataset stage
have better performance by this
project Steps,hits, Project level HArd things,Solved
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
i have a small question for datastage, After the desinging
(i.e., transformations and loading)part, what we can do?