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
Answers were Sorted based on User's Feedback
Answer / priyasen
(10*5) 50 records
this kind of query gives us Cartesian product
Is This Answer Correct ? | 68 Yes | 0 No |
Answer / laxmi soujanya
10*5=50 records
this is cartesian product
Is This Answer Correct ? | 5 Yes | 0 No |
What is a repository manager?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
How many numbers of sessions can one group in batches?
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
what is difference between COM & DCOM?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
can we override a native sql query within informatica? How do we do it?
wht is full process of Information source to target just like stg to productuon and development
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are the features of complex mapping?
What is CHECK-IN CHECK-OUT. Please explane me?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?