what is mapping optimization? wat are the techniques for tat
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between STOP and ABORT options in Workflow Monitor?
Describe data concatenation?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
list out all the transformations which use cache?
What is a stored procedure transformation?
Have you worked with/created Parameter file
Can we create two repositories on same database instance in oracle?
Describe the impact of several join conditions and join order in a joiner transformation?
Is it possible to use a client with different version than that of its Informatica server?
Briefly define a session task?
What are the new features of Power Center 5.0?
During the running session, output files are created by informatica server. Enlist few of them.
What is option by which we can run all the sessions in a batch simultaneously?
Is stop and abort are same in informatica?
what is the size of u r source(like file or table)?