Hi experts,
table 1 has 10 records, table 2 has 5 records
select * from table1, table2;
What is the output for this query???....plz answer
Answer Posted / priyasen
(10*5) 50 records
this kind of query gives us Cartesian product
| Is This Answer Correct ? | 68 Yes | 0 No |
Post New Answer View All Answers
Global and Local shortcuts. Advantages.
How to differentiate between the active and passive transformations?
What is enterprise data warehousing?
What are the types of presistent cache in look up tr.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Can we create a Integration service without a Repository service and vice versa?
What are the designer tools for creating transformations?
How to create a non-reusable instance of reusable transformations?
What is the use of code page?
What are the prerequisite tasks to achieve the session partition?
Clarify the aggregator change?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the meaning of decode in informatica?
wat are deployement groups in informatica, how it will be used for developers