How many Nodes configuration file you used in your last project?
How do you register plug-ins?
Explain ibm infosphere information server and highlight its main features?
what is the differeces between hash and modulus partition methods
What is container and then types?
How can we achive parallelism
How many types of stage?
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
what is time dimension? and how to populate time demension
1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?
Does datastage support slowly changing dimensions ?
Explain the ChangeApply stage?
What is the difference between lookup and sparse lookup?