on how many columns we can perform aggregation in the
Aggregator stage?
Answer Posted / ramesh
any number of columns we can perform aggregation
ex:group by deptno,group by deptname,
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are stage variables and constants?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
in oracle target stage when we use load option and when we use upsert option?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How do you register plug-ins?
What all the types of jobs you developed?
What is use Array size in datastage
Why do you need stage variables?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Why do we use link partitioner and link collector in datastage?
How many types of views are there in a datastage director?