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
- 8192 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
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
what is use of SDR function?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
whom do you report?
client know skid info?
What is the difference between datastage and datastage tx?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Can you explain link buffering?
What is aggtorec restructure operator?
What is the method of removing duplicates, without the remove duplicate stage?
What is the difference between the local container and shared container?
How complex jobs are implemented in datstage to improve performance?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are the important features of datastage?
