deptno wise to find max and min,and sum of rows and in target to company wise ma

deptno wise to find max and min,and sum of rows and in target to company wise maximum

Question Posted / gopipalem

1 Answers
4803 Views
IBM, TCS, I also Faced
E-Mail Answers

deptno wise to find max and min,and sum of rows and in target to company wise maximum..

Answer / nish

could you please elucidate the scenario?
question is half baked

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Data Stage Interview Questions

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

4 Answers L&T,

what are the types of nodes

4 Answers HCL, TCS,

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

5 Answers Cap Gemini,

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers IBM,

by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?

1 Answers

Explain ibm infosphere information server and highlight its main features?

0 Answers

How did you reconcile source with target?

2 Answers HP,

what is snow flack schema?

2 Answers

If you want to use a same piece of code in different jobs, how will you achieve this?

0 Answers

What is "fatal error/rdbms code 3996" error?