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
sed,awk,head
What is ibm datastage flow designer?
What is a merge?
Enlist various types of routines in datastage.
Define APT_CONFIG in Datastage?
How do y read Sequential file from job control?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Explain ibm infosphere information server and highlight its main features?
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?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
How to convert RGB Value to Hexadecimal values in datastage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What are the primary usages of datastage tool?
Does datastage support slowly changing dimensions ?
Can you explain engine tier in information server?