tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
IBM,
2694I 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 5820hi 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 6565create 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 27351what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
1 7999i 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 12097What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
5 8481hi 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 2950Hi 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 9094
What all are the different way to run a job?
What are the primary usages of datastage tool?
What could be a data source system?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Give an idea of system variables.
Have you used Unstructured data?
Demonstrate experience in maintaining quality process standards?
Differentiate between Join, Merge and Lookup stage?
What is the purpose of pivot stage?
What is apt_config in datastage?
What are stage variables and constants?
What is staging variable?
What is the method of removing duplicates, without the remove duplicate stage?
What are the types of containers?
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