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
i want job aborted after some records are loaded into output by using only sequential stage and dataset
i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
Lookup constraints
on how many columns we can perform aggregation in the Aggregator stage?
Highlight the main features of datastage?
What are the main features of datastage?
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
What r the existing server jobs in parallalism?
Have you used Unstructured data?