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
- 9738 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 datastage and datastage tx?
How can you write parallel routines in datastage PX?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Define oconv () and iconv () functions in datastage?
What are the stages in datastage?
What is the difference between hashfile and sequential file?
Define Job control?
Define Routines and their types?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Which commands are used to import and export the datastage jobs?
What are the some differences between 7.x and 8.x version of datastage?
What could be a data source system?
describe the Steps to confiure a Qlogic switch
Why do we use exception activity in Datastage?
How do you run datastage job from the command line?
