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.
What are the differences between perfect competition and Monopoly?
Define the term filter?
Illustrates the term natural key in Sybase?
Explain the usage of the repository connectivity?
Describe briefly the difference between a Java applet and a Java servlet?
Write down the importance for using repository connectivity?
Explain terms Data Cache in Sybase. Answer: It is the memory area where data which is required for the current queries running is bought by Disk upon to memory for
Write about the term metadata in brief.
Explain and compare OBE and SQL?
What do you understand by the term Dataset?
18,76,764
1943566 Asked
3,689
Active Tutors
1417168
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!