ans:select * from table 1,table2? 45 records(cartisan product)

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

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

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

How union transformation is used?

1005

Explain what is informatica metadata and where is it stored?

1049

What is the sequence generator transformation in informatica?

1183

What are the steps involved in the migration from older version to newer version of Informatica Server?

2107

What is resilience time?

1137

what is the difference between informatica6.1 and infomatica7.1

2275

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1510

What all join we can perform in LOOKUP transformation?

975

Performance tuning in UNIX for informatica mappings?

2568

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1946

How to update or delete the rows in a target, which do not have key fields?

1178

What are the main issues while working with flat files as source and as targets ?

1154

Describe an informatica powercenter?

1127

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1064

What is dimensional table?

1061