Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rekha
LOOK UP IS A PASSIVE TRANSFORMATION.
LOOK UP IS USED TO LOOK UP THE DATA IN RELATIONAL TABLES
FLAT FILES ,VIEWS OR SYNONYMS
LOOK UP IS USED TO 1 GET A RELATED VALUE
2 PERFORMING CALCULATIONS
3. UPDATING SLOWLY CHANGING DIMENSIONS
TYPES OF LOOK UP
CONNECTED
UNCONNECTED
CACHED/UNCACHED
| Is This Answer Correct ? | 14 Yes | 5 No |
Post New Answer View All Answers
What are the types of schemas we have in data warehouse and what are the difference between them?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Plz can any one say me how to get the informatica certification materials and dumps
In informatica workflow manager, how many repositories can be created?
Write the prerequisite tasks to achieve the session partition?
What is expression transformation?
What do you mean by enterprise data warehousing?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
how many types of dimensions are available in informatica?
Enlist the various types of transformations.
differences between service based and product based?
waht type of interface is used for testing the data in informatica
permutations of mapplet
How are indexes created after completing the load process?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
