Why we use lookup transformations?
Answer / guest
we use lookup transformation to lookup data in a relational
table ,view or synonym.and by using lookup transformation
we can perform the following jobs
-to get the related value
-to perform the calculations
-to update the slowy changing dimentions
| Is This Answer Correct ? | 3 Yes | 1 No |
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?
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
Describe an informatica powercenter?
What are the rank caches?
How can you validate all mappings in the repository simultaneously?
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
4 yrs etl devloper roles and responsibilities?any body give solutions
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
How to create or import flat file definition in to the warehouse designer?
How do you convert single row from source into three rows into target?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is the difference between a repository server and a powerhouse?