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
- 9619 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 is the difference between orabulk and bcp stages?
root tree will find which is server job and which is parallel job?
Does datastage support slowly changing dimensions ?
what is use of SDR function?
What are the types of hashed files in data stage
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Define project in datastage?
What is the precedence of stage variables,derivations, and constraints?
What is "fatal error/rdbms code 3996" error?
What is a merge?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the different common services in datastage?
How can one find bugs in job sequence?
Can you define merge?
How can we improve the performance in datastage?
