i having source like emptable,dept table and combined
purpose using for the join stage but join stage which
partition techq will be prefored?
pls given the ans?

Answers were Sorted based on User's Feedback



i having source like emptable,dept table and combined purpose using for the join stage but join st..

Answer / upputuri.vinod

DUDE JOIN STAGE USES THE HASH PARTITION STAGE..

Is This Answer Correct ?    7 Yes 0 No

i having source like emptable,dept table and combined purpose using for the join stage but join st..

Answer / san

When ever you want join the two files .. you need to do hash
partition using natural keys both sides. Otherwise the value
related keys will go into different partitions and while
join match will not occur properly.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Data Stage Interview Questions

1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

6 Answers   CTS, HCL, IBM, Wipro,


What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,


hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

4 Answers   IBM,


Explain the datastage parallel extender (px) or enterprise edition (ee)?

0 Answers  


What are the types of containers and how to create them?

0 Answers  






I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,


what is the Difference Between Datastage Server Edition and Parallel Edition?

2 Answers   Tech Mahindra,


How did you reconcile source with target?

2 Answers   HP,


how can we join one oracle & flat files ?

2 Answers   ME,


how to call sequential generator in datastage?

1 Answers   IBM,


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

0 Answers  


How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  


Categories