Interested to Buy Any Domain ? << Click Here >> for more details...
what is mapping optimization? wat are the techniques for tat
- 2 Answers
- 7722 Views
- I also Faced
- E-Mail Answers
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 |
How to generate sequence numbers?
What do you mean incremental aggregation?
EXL informatica Questions
What is the difference between warehouse key and surrogate key?
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
Is it possible to use a client with different version than that of its Informatica server?
source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?
Can we insert ,update ,delete in target tables with one update strategy tran.?
What do you mean by filter transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Enlist the differences between database and data warehouse.
What is the difference between a connected look up and unconnected lookup?
Teradata 
