what is the best stage in datastage parller jobs to use full
out join and why
- 5 Answers
- 16254 Views
- Virtusa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vinay kumar
join stage is the best,why means data getting from buffer
area.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / swetha
use the join stage rather than using lookup and merge stages. join stage supports all the joins like inner join,leftouter join,right outer join,full outer join
lookup supports only inner,leftouter only
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / bharath
Hi,
Join stage is best 4 full outer join bcoz
lookup is RAM intensive where as join uses less memory.
| Is This Answer Correct ? | 1 Yes | 0 No |
join is the best because join uses the less memory compare with lookup
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the unix script to run the job? Please mention commands which we use often?
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
How to move data set from one server to other?what are the steps to follow to do this?
how many stages are there in Datastage... Please clarify mee??
how will u design file watch jobs?
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 are the third party tools you used in your project?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
WHAT are unix quentios in datastage
Teradata 
