Can aggregator and transformer stages use to sort the data?
How ?
Answers were Sorted based on User's Feedback
Answer / kumar
go to partition--->select the partiton name other than auto-
-->check perform sort.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / srinivas
We can sort the data by using Aggregator and Transformer
If we use the Aggregator will get only specified coulmns will not get all source columns.
If we use the transformer will get all columns with sorted output.
Is This Answer Correct ? | 1 Yes | 0 No |
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
how to call sequential generator in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
Define meta stage?
What is mapping?
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records
Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S
Why do you need stage variables?
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
How we can covert server job to a parallel job?
What is the difference between validated and compiled in the datastage?