Interested to Buy Any Domain ? << Click Here >> for more details...
How to identify bottlenecks in
sources,targets,mappings,workflow,system and how to
increase the performance?
- 4 Answers
- 35427 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinu
identification of bottelnecks
target:configuring session to write to flatfiletarget
source:add filter t/r after sq t/t to false show that no
data is processed past the filter t/r,if it time takes to
run new session remains same to the original session there
is source bottel necks
mapping:add filter t/f before each target and set filter
condition to false,similar to source
session:use the collect performance data to identify the
session bottel necks
read from desk,write to disk counters other than zero,there
is bottelnecks
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
What is blocking transformation?
Explain sql transformation in script mode examples in informatica
What is an aggregator transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the need of an ETL tool?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Which is the t/r that builts only single cache memory?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is lookup transformation?
What are the different types of olap? Give an example?
Explain how to import oracle sequence into informatica?
How do you set a varible in incremental aggregation
What is status code in informatica?
What is the scenario which compels informatica server to reject files?
