Answer Posted / suresh
.Net frame work,oracle 9i,Datastage 7.5 PX software
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to reverse the string using unix?
How the ipc stage work?
AGGREGATOR default datatype
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is quality stage?
What is the difference between in process and inter process?
What is a merge?
How do you remove duplicate values in datastage?
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.
Describe the architecture of datastage?
Why do we use link partitioner and link collector in datastage?
Can you explain repository tables in datastage?
State the difference between an operational datastage and a data warehouse?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?