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)
885Source 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 rejected rows are managed in datastage?
What are routines in datastage?
Can you implement SCD2 using join, transformer and funnel stage?
What is the difference between hashfile and sequential file?
Define orabulk and bcp stages?
How many Key we can define in remove duplicate stage?
what is the difference between == and eq in UNIX shell scripting?
Describe the main features of datastage?
Explain how a source file is populated?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
If you want to use the same piece of code in different jobs, how will you achieve it?
What are the processing stages?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are the important features of datastage?
options available in sequence job to run,validate?