for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
No Answer is Posted For this Question
Be the First to Post Answer
How do you import and export the datastage jobs?
Does datastage support slowly changing dimensions ?
Two source files contains same meta data third file contains different data types can I funnel that file.
How can you join flat file, oracle as a sources?
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
What is the difference between validated and compiled in the datastage?
Difference between sequential file and data set?
project Steps,hits, Project level HArd things,Solved methods?
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)
What is process model?
What are datastage sequences?
how to cleansing data