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 is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is a standalone command task?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain sql transformation in script mode examples in informatica
Differentiate between reusable transformation and mapplet.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What do you mean by filter transformation?
Tell me about Propagate functions in informatica
update strategy transformation in informatica
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Slowly changing dimensions, types and where will you use them
Explain in detail about scd type 1 through mapping.
Which files are created during the session rums by informatics server?
what is the -ve test case in your project.
What are the popular informatica products?
