I have scenario like this seq file --> transformer --> sort
stage --> dataset
In this job which prtitioning technique you are using and
why???
Answer Posted / ashok
we want write partition on integer type field like deptno
then go to modulus other wise go to hash is better in
performance wise
| Is This Answer Correct ? | 12 Yes | 5 No |
Post New Answer View All Answers
Define Merge?
What is the method of removing duplicates, without the remove duplicate stage?
Can you explain repository tables in datastage?
CHANGE CAPTURE
How one source columns or rows to be loaded in to two different tables?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
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)
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is the roundrobin collector?
AGGREGATOR default datatype
project Steps,hits, Project level HArd things,Solved methods?
Is possible to create skid in dim,fact tables?
Can you explain kafka connector?
What is the purpose of interprocessor stage in server jobs?
Define APT_CONFIG in Datastage?