Answer Posted / chansra
if source having duplicate rows then we can use
dynamic...otherwise we can use static
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is dimensional table? Explain the different dimensions.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How can a transformation be made reusable?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How to create the source and target database connections in server manager?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the different versions of informatica?
What is informatica worklet?
What is rank transformation in informatica
What is decode in static cache?
What are the transformations that are not supported in mapplet?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What the difference is between a database, a data warehouse and a data mart?
How many dimensions are there in informatica?
what is informatica metadata?
