Interested to Buy Any Domain ? << Click Here >> for more details...
when will we use unconnected & connected lookup? How it
will effect on the performance of mapping?
- 5 Answers
- 16432 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / jeevan kumar medapati
if u want to perform look up on less values then we go for
connected lkp
if u want to perform look up from more than one table then
we go for un connected lkp
in ur source u have more date columns then we should go for
unconnected lkp.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are the main features of Oracle 8i with context to datawarehouse?
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the differences between oltp and olap?
what is the size of your data warehousing?
What is workflow? What are the components of workflow manager?
Where is metadata stored?
COM components can be used in Informatica
What is the benefit of session partitioning?
Name the different lookup cache(s)?
Explain how to import oracle sequence into informatica?
Explain the etl program with few examples.
Design a mapping to load the cumulative sum of salaries of employees into target table?
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
Explain the types of transformations?
