Interested to Buy Any Domain ? << Click Here >> for more details...
A table containg 100 records B table containg 20 records we
have to join two tables in left outer it containg target 100
records but target containg 101 record at that time what is
the issue arise
- 3 Answers
- 9487 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / geetha
Extra 1 records is populated in case of duplicate records in the reference tables. lets say we have emp_id A in left table and we have two emp_id A ,in this case we will have duplicate records in the output.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what are the devoleper roles in real time? plz tell i am new to datastage....
What are the enhancements made in datastage 7.5 compare with 7.0?
What is merge stage?
What are datastage sequences?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is process model?
What is the difference between odbc and drs stage?
To see hidden files in LINIX?
Describe routines in datastage? Enlist various types of routines.
Explain the importance of surrogate key in data warehousing?
How many Key we can define in remove duplicate stage?
What are the areas of application?
Difference between in process and inter process?
How do you register plug-ins?
What is difference between symmetric multiprocessing and massive parallel processing?
