Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1

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

Question Posted / baladevshree

3 Answers
7271 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is t..

Answer / priyasen

(10*5) 50 records
this kind of query gives us Cartesian product

Is This Answer Correct ?

68 Yes

0 No

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is t..

Answer / laxmi soujanya

10*5=50 records

this is cartesian product

Is This Answer Correct ?

5 Yes

0 No

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is t..

Answer / dinesh

ans:select * from table 1,table2?

45 records(cartisan product)

Is This Answer Correct ?

0 Yes

31 No

Post New Answer

More Informatica Interview Questions

in which situations do u go for snowflake schema ?

2 Answers TCS,

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers TCS,

why we use source qualifier transformation?

16 Answers Accenture,

what is the difference between lookupoveride and joiner?

3 Answers

How big was your fact table

0 Answers

What is workflow manager?

0 Answers

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers CSC, iNautix,

What is predefined event?

1 Answers

what is DSS?

3 Answers

How mapping parameter and variable works

1 Answers

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

1 Answers IBM,

For more Informatica Interview Questions Click Here