create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null?
empid salary previoussalary
10 1000 null
20 2000 1000
30 3000 2000
40 4000 3000
i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"
i have a problem in my project..
Native Error Code: -407 "Assignment of a null value to a not null column"
i have no idea, what should i do..please help :(
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
how can we create rank using datastage?what is the meaning of
8000 jobs r there i given commit, suddenly job will abort?
2)diff b/t transformer stage & filter stage?
3)how to load the data in the source?
How many Nodes configuration file you used in your last project?
How can we perform 2nd time extraction of client database
without accepting the data which is already loaded in first
Display all files which have size more 3KB in given directory/folder.
How to lode data in sequntional files perform faster?
how many rows sorted in sort stage by default in server jobs
1)what is the size of Fact table and dimension table?
2)how to find the size of Fact table and dimension table?
3)how to implement the surrogate key in transform stage?
4)write the configuration file path?
5)how many types of datasets explain?
6)diff b/w developed projects and migration projects?
7)how to delete the header and footer file of the sequencer
8)how can u call the parameters in DS in unix environment?
9) how much data ur getting daily ?
what are the errors,warnings in datastage
Could anyone give brief explanation bout datastage admin
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What is process model?
disign the complex job in u r project?(they are aksing only
complex job design and then data flow...)
How can we perform the 2nd time extraction of client
database without accepting the data which is already loaded
in first time extraction?
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?