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
- 7362 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / laxmi soujanya
10*5=50 records
this is cartesian product
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is flashback table ? Advance thanks
Explain pmcmd command usage in informatica
What is the Rank index port in Rank transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How we can create indexes after completing the load process?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What are session parameters ? How do you set them?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is Session and Batches?
What is a joiner transformation and why it is an active one?
What is Index Caches size?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
COM components can be used in Informatica
