If we take 2 tables(like emp and dept),we use join stage
and how to improve the performance?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Stage Interview Questions

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,


What is the precedence of stage variables,derivations, and constraints?

0 Answers  


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

0 Answers  


1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project

1 Answers   Accenture,


Define repository tables in datastage?

0 Answers  






how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 Answers  


How and where you used hash file?

0 Answers  


I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage

3 Answers   IBM,


What is ibm datastage flow designer?

0 Answers  


what is operator combinality in datastage?

1 Answers   TCS,


can a fact table contains textual information

6 Answers   HCL, HCL BSERV, IBM,


What is a folder? Difference types of stages?

0 Answers  


Categories