which memory is used by lookup and join

Answer Posted / raam chowdary

join is used in permanent memory and lookup is used in buffer(ram)

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which warehouse using in your datawarehouse

1688


What is the difference between orabulk and bcp stages?

588


describe the Steps to confiure a Qlogic switch

1946


DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1045


What all are the different way to run a job?

649






What is "fatal error/rdbms code 3996" error?

670


Define orabulk and bcp stages?

696


table actions available in oracle connector?

1101


How many areas for files does datastage have?

649


options available in sequence job to run,validate?

848


What is difference between symmetric multiprocessing and massive parallel processing?

664


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

1792


how to write server Routine coding?

1671


How to implement complex jobs in data stage?

621


What are the types of containers?

701