Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 148600 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / pavan
We go for a join stage than a lookup when the referntial
data in look up is more ie.,>=500MB.we have outer joins in
join stage but not in merge stage.we have only inner join
in merge stage.
| Is This Answer Correct ? | 12 Yes | 26 No |
Post New Answer View All Answers
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
what are the errors,warnings in datastage
Which warehouse using in your datawarehouse
What is the purpose of pivot stage and types of containers 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 are the repository tables in datastage?
What is the difference between orabulk and bcp stages?
CHANGE CAPTURE
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What are the functionalities of link partitioner?
How a source file is populated?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Difference between server jobs & parallel jobs?
What is the flow of loading data into fact & dimensional tables?
What is a folder? Difference types of stages?
