Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shar
1.Inputs as left right and intermediate links(files).
2.can do left outer,right outer,inner join and full outer join
3.N inputs for left,right and inner but 2 inputs for full outer.
4.Inputs should be sorted and partitioned for better
performance.
5.Removing duplicates is optional as join operation is
highly optimized which sequential and less i/o and less page
faults.
6.Memory requirements are comparatively less than Lookup stage.
7.In join key columns names should be same in primary and
secondary datasets.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Enlist various types of routines in datastage.
Define oconv () and iconv () functions in datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
what is ds administrator used for?
how do u catch bad rows from OCI stage? And what CLI stands for?
Differentiate between Join, Merge and Lookup stage?
What is the roundrobin collector?
Differentiate between hash file and sequential file?
How do you schedule or monitoring the job?
What are the main differences you have observed between 7.x and 8.x version of datastage?
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?
how to export or import the jobs in .ISX file
What are the steps needed to create a simple basic datastage job?
What is the flow of loading data into fact & dimensional tables?
What are the types of views in datastage director?
