Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7270 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
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
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
How identifying bottlenecks in various components of informatica and resolving them?
my source is junk data how will u remove that junk data by using unix please any one replay me
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
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.
What is Session and Batches?
What is the Process to creating lookup transformation in informatica
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is informatica metadata and where is it stored?
What is rank index in rank transformation?
Explain the aggregator transformation?
What do mean by local and global repository?
What is a sequence generator transformation?
