Interested to Buy Any Domain ? << Click Here >> for more details...
what is mapping optimization? wat are the techniques for tat
- 2 Answers
- 7658 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 |
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
where actually the usage of push down optimization happens...
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
update strategy transformation in informatica
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
Enlist the advantages of informatica.
What do you understand by a term domain?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
Explain the use of aggregator cache file?
Teradata 
