Configure mapping in informatica
Describe briefly How can we configure mapping in the informatica?
Expert
We must configure the mapping with least number of transformations and expressions to do most amount of work possible. You must minimize the amount of a data moved through deleting needless links between transformations. For transformations which employ data cache (like Joiner, Aggregator, Lookup, and Rank transformations) limit connected input or output or output ports. Limiting the number of a connected input or output or output ports decreases the amount of data transformations store into the data cache.
We can also execute the subsequent tasks to optimize mapping which are illustrated below:
i) Configure single-pass reading. ii) Optimize data type conversions. iii) Eliminate transformation errors. iv) Optimize transformations.
Optimize expressions: We must configure the mapping with least number of the expressions and transformations to do most amount of work possible. We must minimize amount of data moved through deleting needless links between transformations. For transformations which employ data cache (like Joiner, Aggregator, Lookup, and Rank transformations) limit connected input or output or output ports. Limiting the number of a connected input or output or output ports decreases the amount of data transformations store into the data cache.
Explain the loops?
Explain the Equilibrium Price in brief.
Describe some of the chrematistics of good data definitions.
Assume when a session fails subsequent to loading of 10,000 records in to target. How can we load the records from 10001 the record when we run session next time?
Specify the several Business Objects products?
Describe briefly the term data warehouse?
Specify the tasks of universe designer?
Describe briefly the term SQL Server Analysis Services cubes?
Explain how is the HASH file used and where we can use it?
Explain some of the data mining tools.
18,76,764
1955793 Asked
3,689
Active Tutors
1434794
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!