Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
No Answer is Posted For this Question
Be the First to Post Answer
What is diff between Junk dimensions and conform dimension?
how to cleansing data
What are orabulk and bcp stages?
can explain wt is the pool for file.
Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?
Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
What is the Difference Between DataStage 7.5 version and 8.1 Version?
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 want job aborted after some records are loaded into output by using only sequential stage and dataset
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How many nodes supported by a one cpu in parallel jobs?