Can aggregator and transformer stages use to sort the data?
How ?
Answer Posted / kumar
go to partition--->select the partiton name other than auto-
-->check perform sort.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What can we do with datastage director?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Define repository tables in datastage?
What are routines in datastage? Enlist various types of routines.
Can you explain tagbatch restructure operator?
What could be a data source system?
Does datastage support slowly changing dimensions ?
Name the different types of Lookups in Datastage?
Lookup constraints
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What is the difference between validated and compiled in the datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is the flow of loading data into fact & dimensional tables?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is the purpose of pivot stage and types of containers in datastage