Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / priya
look up transformation is used to look the data either from
source or target whenever the req feild is not in the
mapping.
we can use two or more tables as look up by using the join
condition
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Scheduling properties,whats the default (sequential)
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain how many types of dimensions are available in informatica?
What is lookup change?
How many types of sessions are there in informatica.please explain them?
Define Pmrep command?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what is informatica metadata?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
design of staging area?
Differences between version 7.x and 8.x.
What are multi-group transformations?
how to load dimension table and fact table. plz tell me the steps.
