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
- 16585 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
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
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
What are the informatica performance improvement tips
if we have a delimiters at unwanted places in a flat file how can we over come those.
Explain the etl program with few examples.
How can you define user defied event?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How can you increase the performance in joiner transformation?
What all are steps in up gradation of Informatica server?
How to generate sequence numbers without using the sequence generator transformation?
What are the different types of olap? Give an example?
Define enterprise data warehousing?
have u done any performance tuning? how u ll do?
