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
- 9577 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 types of views in datastage director?
how many rows sorted in sort stage by default in server jobs
what is ds administrator used for?
On which interface you will be working as a developer?
How a source file is populated?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Which algorithm you used for your hashfile?
What is oci?
What is the use of hoursfromtime() function in transformer stage in datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is the difference between validated and compiled in the datastage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Does datastage support slowly changing dimensions ?
root tree will find which is server job and which is parallel job?
Notification Activity
