CHANGE CAPTURE
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Name the different sorting methods in datastage.
What is the difference between the local container and shared container?
Can you explain players in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
What are the different layers in the information server architecture?
Differentiate between datastage and datastage tx?
What is active and passive stage?
AGGREGATOR default datatype
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are the different common services in datastage?
What are the benefits of datastage?
client know skid info?
Explain ibm infosphere information server and highlight its main features?