how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
889Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
745
How complex jobs are implemented in datstage to improve performance?
What are the steps needed to create a simple basic datastage job?
What are the components of datastage?
how many rows sorted in sort stage by default in server jobs
What are stage variables?
Define Data Stage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
root tree will find which is server job and which is parallel job?
Triggers,VIEW,Procedures
What are the different common services in datastage?
Why we use surrogate key?
Which warehouse using in your datawarehouse
Where the datastage stored his repository?
How to manage date conversion in Datastage?