What are the prerequisites for join stage
Answers were Sorted based on User's Feedback
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 |
How to transfer file from one system to another system in UNIX?which command to be use?
HOW CAN WE SEE THE DATA IN DATASET?
Main Function of the Staging area in DWH ?
what are the devoleper roles in real time? plz tell i am new to datastage....
I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..
9 Answers Cognizant, IBM, TCS, Virtusa,
how many types of remove the duplicate records?
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
What are the functionalities of link collector?
How you Remove the Dataset in Unix?
sed,awk,head
what is the use of DSattchJob?DetachJob? where can we find it?
How you can fix the truncated data error in datastage?