Interested to Buy Any Domain ? << Click Here >> for more details...
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
- 1 Answers
- 7273 Views
- TCS, I also Faced
- E-Mail Answers
Answer / gurpreet singh
Normal Join - All matching rows of A and B
Master Outer join - All rows of detail including matching
rows from master
Detail Outer join - All rows of Master including matching
rows from detail.
Full outer join - All rows from Master and detail table
including matching rows.
| Is This Answer Correct ? | 14 Yes | 0 No |
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
what is constraint based loading
What is the filename which you need to configure in UNIX while installing infromatica?
what is fact table?
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
How does the server recognize the source and target databases. Elaborate on this.
what is the difference between repository & Intergration service
What does command task mean?
What are reusable transformations in how many ways we can create them?
Teradata 
