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
Clarify the utilization of aggregator cache record?
What is the difference between informatics 7x and 8x and what is latest version?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Which transformation should we use to normalise the COBOL and relational sources?
How do you take back up of repository?
what is song in infrmatica...?
What is DR strategy for Informatica project?
How to open an older version of an object in the workspace?
Differentiate between reusable transformation and mapplet.
What is session task and command task?
Explain your project of banking domian.
can anyone explain me about retail domain project in informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
What the difference is between a database, a data warehouse and a data mart?