Interested to Buy Any Domain ? << Click Here >> for more details...
Difference in the implementation of lookup and join
stages,in joining two tables?
- 7 Answers
- 16655 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / zulfi123786
Hi This is Zulfi
Basically Join is used when you have large amount of data
about in millions and it performs inner join,left
outer,right outer and full outer joins
The join stage requires the incomming data to be hash
partitioned and sorted on the joining keys
The look up is used when the reference records are fewer in
number about less than one lakh and it doesnot require the
incomming source data to be sorted, instead the refrence
link should be in Entire partition mode.
In look up there are two types
Normal and Sparse
Sparse is available only when the reference is a database.
usually Normal has to be used unless when the refrence to
source rows ratio is 100:1
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How do you reject records in a transformer?
Can you explain players in datastage?
Describe the main features of datastage?
EXPLAIN SCD
What is the difference between odbc and drs stage?
AGGREGATOR default datatype
How rejected rows are managed in datastage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
what are the errors,warnings in datastage
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Difference between sequential file and data set?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
