what is the best stage in datastage parller jobs to use full
out join and why
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 |
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
Differentiate between data file and descriptor file?
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
How can remove duplicates in a file using UNIX?
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
In one project how many shared containers are created?
deptno wise to find max and min,and sum of rows and in target to company wise maximum
what is time dimension? and how to populate time demension
How do you design PX Routines ?
4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail
WHAT are unix quentios in datastage