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)
886Source 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
Whats difference betweeen operational data stage (ods) and data warehouse?
Name the different sorting methods in datastage.
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are the types of views in datastage director?
table actions available in oracle connector?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How many Key we can define in remove duplicate stage?
What is apt_config in datastage?
Is the value of staging variable stored temporarily or permanently?
How to perform incremental load in datastage?
How a server job can be converted to a parallel job?
What is the use of hoursfromtime() function in transformer stage in datastage?
what is use of SDR function?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do