tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
IBM,
3124I 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
1 6768hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" hi everbody, 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 :(
3 7768create 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
5 29871what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
1 8834i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc Ple help any one?
4 14278What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
5 10304hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
HCL,
1 3717Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is Empno 1 2 3 4 5 6 7 8 9 10
5 10878
How to reverse the string using unix?
Explain usage analysis in datastage?
What are some different alternative commands associated with "dsjob"?
What is meta stage?
How can you write parallel routines in datastage PX?
What is ibm datastage?
Name the different types of Lookups in Datastage?
how can we create rank using datastage?what is the meaning of rank?
What is the difference between datastage and datastage tx?
options available in sequence job to run,validate?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
how many rows sorted in sort stage by default in server jobs
what is repositery?
What are the job parameters?
What are the components of datastage?