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 |
What are the types of jobs we have in datastage?
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
Main Function of the Staging area in DWH ?
What is merge stage?
can we half project in parallel jobs and half project in server jobs?
when u face critical situation in ur project, how to solve them?
can we see the data in fixed width file? how can u change the datatype of fixed width files?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Why we use surrogate key?
what is ds administrator used for?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5