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 / dinesh

ans:select * from table 1,table2?

45 records(cartisan product)

Is This Answer Correct ?    0 Yes 31 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different ways to implement parallel processing in informatica?

864


What is a connected transformation?

674


What are the different options available for update strategy?

580


How to delete duplicate row using informatica?

610


Differentiate between reusable transformation and mapplet.

574






How many input parameters can exist in an unconnected lookup?

992


How do you load alternate records into different tables through mapping flow?

1294


Global and Local shortcuts. Advantages.

1468


What is the sequence generator transformation in informatica?

613


What is meant by lookup transformation? Explain the types of lookup transformation?

567


What is a rank transform?

676


Describe the impact of several join conditions and join order in a joiner transformation?

649


What is informatica etl tool?

554


What you know about transaction control transformation?

559


What is the difference between Active and Passive transformation?

633