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 |
which cache supports connected & un connected Lookup
What are the types of jobs we have in datastage?
Can you explain link buffering?
What is oci?
Enlist various types of routines in datastage.
how to cleansing data
how many dimentions and fact tables used in your project and what are names of it?
Define oconv () and iconv () functions in datastage?
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
What is the use of datastage designer?
Different ways a project can be moved to production ?...example ….export-import and Version control.
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?