I have scenario like this seq file --> transformer --> sort
stage --> dataset
In this job which prtitioning technique you are using and
why???
Answer Posted / kiran
Hash partition or modulus partition. When using sort
operations always better to go for key partition techniques.
| Is This Answer Correct ? | 40 Yes | 4 No |
Post New Answer View All Answers
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)
What is meta stage?
What are the functionalities of link partitioner?
How to reverse the string using SQL?
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?
What are stage variables and constants?
What is the difference between Datastage 7.5 and 7.0?
Lookup constraints
what are the devoleper roles in real time? plz tell i am new to datastage....
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What are the different kinds of views available in a datastage director?
Demonstrate experience in maintaining quality process standards?
Can you explain engine tier in information server?
How a server job can be converted to a parallel job?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?