Answer Posted / saribalareddy
Whenever you create the target table whether you are store the historical data or current transaction data in to target table.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
have u done any performance tuning? how u ll do?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the difference between a repository server and a powerhouse?
What are the components of the workflow manager?
whats the logic to load the lower level of granularity of data to fact table.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is the difference between informatica 7.0 and 8.0?
Did u used latest transformations of 8.6.0? for what?
What are the performance considerations when working with aggregator transformation?
What differs when we choose the sorted input for aggregator transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is the difference between stop and abort in informatica
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?
What is a grid in Informatica?
Explain the types of lookup transformation?