tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Define Job control?
how do u reduce warnings
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time
if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?
Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/
i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?
what is the unix script to run the job? Please mention commands which we use often?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Give an idea of system variables.
how to delete one row in target dataset
Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.
can we see the data in fixed width file? how can u change the datatype of fixed width files?