Interested to Buy Any Domain ? << Click Here >> for more details...
what is mapping optimization? wat are the techniques for tat
- 2 Answers
- 7662 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 the basic requirements to join two sources in a source qualifier transformation using default join?
What are the types of schemas we have in data warehouse.
What is the use of code page?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
what are 3 tech challenges/ common issues you face?
how we can load rejected record's at run time?(not through bad files)
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Can anyone tell me the new features in Informatica 9 Version?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How can we remove the duplicates from flat file source?
What is meant by active and passive transformation?
What is rank index in rank transformation?
What is the reusable transformation?
What is the difference between a repository server and a powerhouse?
