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
- 3 Answers
- 6387 Views
- TCS, I also Faced
- E-Mail Answers
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
What is rank transformation?
Tell me about MD5 functions in informatica
In warehouses how many schemas are there?
What is a pre-defined event and user-defined event?
What are the restrictions of union transformation?
What is the command used to run a batch?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain the difference between a data warehouse and a data mart?
How to extract sap data using informatica? What is abap? What are idocs?
Define mapplet?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
Could you explain what is enterprise data warehouse?
Name the different lookup cache(s)?
What are the different transaction levels available in transaction control transformation?
During the running session, output files are created by informatica server. Enlist few of them.
