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
- 9610 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
Which warehouse using in your datawarehouse
how to implement scd2 in datastage 7.5 with lookup stage
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is datastage?
How to read multiple files using a single datastage job if files have the same metadata?
What are the difference types of stages?
Is it possible to query a hash file?
What are iconv and oconv?
How many types of views are there in a datastage director?
Could anyone give brief explanation bout datastage admin
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?
What is active and passive stage?
describe the Steps to confiure a Qlogic switch
Can you explain kafka connector?
Explain the situation where you have applied SCD in your project?
