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
1295what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
1028I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
9521. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
1 1427file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
887how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
751
What is ibm datastage flow designer?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is the difference between datastage and datastage tx?
root tree will find which is server job and which is parallel job?
What is ibm datastage?
Could anyone give brief explanation bout datastage admin
Explain entity, attribute and relationship in datastage?
project Steps,hits, Project level HArd things,Solved methods?
Differentiate between datastage and datastage tx?
What is size of a transaction and an array means in a datastage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are the steps required to kill the job in Datastage?
What is difference between join, merge and lookup stage?
What are routines in datastage?