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)
- 0 Answers
- 866 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.
Which algorithm you used for your hashfile?
Distinguish between informatica & datastage. Which one would you choose and why?
what is A Datastage?
How do u convert the columns to rows in datastage?
how to run jon in unix back round process what is command use in runing a job?
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
What are the types of containers and how to create them?
What is the purpose of pivot stage?
can we half project in parallel jobs and half project in server jobs?
Can we use Round Robin for aggregator?is there any benefit underlying?
Teradata 
