Answer Posted / ankit kansal
As a denormalized table structures for a database the number
of joins to fetch the data turns out to be less and hence selection to the data becomes faster.
selecting data from one table is always better than selecting the same data from multiple tables.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
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 are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How do you change a non-reusable transformation to reusable transformation?
How do you convert single row from source into three rows into target?
What do you mean by enterprise data warehousing?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is a repository manager?
What is the benefit of partitioning a session?
Define Pmrep command?
How to configure mapping in informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How to delete duplicate row using informatica?
How do you take back up of repository?
Is it possible to create multiple domains on a single Informatica server?