Interested to Buy Any Domain ? << Click Here >> for more details...
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)
878Source 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
743
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
I have a few records just I want to store data in to targets cycling way how?
How will you move hashed file from one location to another location?
What is the process of killing a job in datastage?
What are the various kinds of containers available in datastage?
What are the types of views in datastage director?
what is repositery?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How to implement complex jobs in data stage?
How do you start developing a datastage project?
what is use of SDR function?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is oci?
How the ipc stage work?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
