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
- 708 Views
- I also Faced
- E-Mail Answers
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
Why do we use exception activity in Datastage?
Define Data Stage?
How to read multiple files using a single datastage job if files have the same metadata?
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
Triggers,VIEW,Procedures
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
Have you used Unstructured data?
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?
what are the errors,warnings in datastage
in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?
How do you load dimension data and fact data? Which is first
Teradata 
