Answer Posted / nagarjuna redd
Use to Lookup a data of table,view and synonym from a
relational or flat files. U can use multiple lookup
transformations in mapping.
- Used to get a related value
- used to perform a calculation
- mainly used in slowly changing dimension
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How can you differentiate between powercenter and power map?
What are the components of workflow manager?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How to call shell scripts from informatica?
Define mapplet?
What is informatica?
What are the new features of informatica 9.x in developer level?
What is dimensional table? Explain the different dimensions.
what is the size of your data warehousing?