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)
No Answer is Posted For this Question
Be the First to Post Answer
Can you filter data in hashed file?
when we have to go for a sequential file stage & for a dataset in datastage?
What modeling tool do you use?
Define orabulk and bcp stages?
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
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
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
How can we achive parallelism
Why do you need stage variables?
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.
wt is the difference between swith and filter stage