what is mapping optimization? wat are the techniques for tat
Answers were Sorted based on User's Feedback
*Use sorted input in Aggretator transformation to decrease
the use of aggregate caches.If you use a Filter
transformation in the mapping, place the transformation
before the Aggregator transformation to reduce unnecessary
aggregation.
* We can use the Source Qualifier transformation to filter
as an alternate way to filter rows.
* Perform joins in a database when possible rather using a
joiner transform
*Adding an index to the columns used in a lookup condition
if you have privileges to modify the database containing a
lookup tables.
these are some simple techniques
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / madhava
To increase the running performance on mapping level.
Techniques of mapping optimization has follow:
1). If its having Filter TX on your mapping place it on
close to the SourceQualifier TX.
2). If in case you are having two or more same DB sources,
use the SQL Override and join it(Instead of Joiner).
3). Use the cache on lookup, Joiner, Aggregator TX. ; etc..
Is This Answer Correct ? | 3 Yes | 1 No |
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What all are steps in up gradation of Informatica server?
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
hw cn v elimate dublicate values from lookup without overriding sql?
how to insert header after each group.
what are surrogate keys?
What is the session task and command task?
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
What is the difference between Power Centre and Power Mart?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?