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
4870 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

Distinguish between informatica & datastage. Which one would you choose and why?

0 Answers

Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain

2 Answers

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers ABC,

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers Caterpillar,

Differentiate between operational datastage (ods) and data warehouse?

0 Answers

how do you pass parameters in a script?

1 Answers L&T,

i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

8 Answers IBM,

hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...

5 Answers

explain about citrix scheduling tool in datastage

0 Answers HSBC,

what is the use of invokation id

2 Answers IBM,

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

5 Answers Gallega, TCS,

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers TCS,

For more Data Stage Interview Questions Click Here