Interested to Buy Any Domain ? << Click Here >> for more details...
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
IBM,
3181I 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 6851hi 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 7895create 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 30087what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
1 8910i 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 14443What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
5 10479hi 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 3790Hi 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 11043
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 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 ?
What are the primary usages of datastage tool?
What are constraints and derivations?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What is a ds designer?
What steps should be taken to improve Datastage jobs?
What is the use of datastage director?
What is the difference between an operational datastage and a data warehouse?
CHANGE CAPTURE
What are sequencers?
Explain Quality stage?
How many types of hash files are there?
what is repositery?
Define ds designer?
What is usage analysis in datastage?
