Interested to Buy Any Domain ? << Click Here >> for more details...
what is mapping optimization? wat are the techniques for tat
- 2 Answers
- 7698 Views
- I also Faced
- E-Mail Answers
Answer Posted / satya
*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 |
Post New Answer View All Answers
What are multi-group transformations?
What is a snowflake schema?
What is target designer and target load order?
How are the sources and targets definitions imported in informatica designer?
How do you update the records with or without using update strategy?
Explain about Informatica server process that how it works relates to mapping variables?
What are the types of caches in lookup? Explain them.
How to create Target definition for flat files?
Quickly characterize reusable change?
Mention few advantages of router transformation over filter transformation.
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
How to extract the informatica rejected data?
Differentiate between a database and data warehouse?
Enlist some properties of sessions.
How do you take back up of repository?
