What is ThroughPut in Informatica, How it works, Where I
can find this option to check ?
Answers were Sorted based on User's Feedback
thoughtput is the rate at which power centre server read
the rows in bytes from source or write the rows in bytes
into the target per second.
U can find this option in workflow monitor.
right click on session choose properties and transformation
statictics tab u can find thoughtput details fro each
instance of source and target.
| Is This Answer Correct ? | 29 Yes | 3 No |
Answer / usha
ThroughPut in Informatica means
per 1sec how many records loaded in to target and
and
Per 1sec how many records fetched from source.
right click on session -->get run properties-->
statistics there we can see throughput
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / krithi
Hi Sri,
You can find this option in Workflow Monitor. It helps you
to monitor the data reads from source or writes to target
in rows per second. Based on this we can monitor and do the
required performance tuning at the target level or source
or database level,if the through put is very low.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / sri
Deepti,,,Thanks,,,
Thoughtput gives Records data in (no of Bytes per sec or
no of rows per sec).?
How can i find 1byte= __rows ?
| Is This Answer Correct ? | 3 Yes | 2 No |
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
one source to target loading insert new rows and update existing rows?
Can you access a repository created in previous version of Informatica?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Describe two levels in which update strategy transformation sets?
how eliminate the duplicates in flat file with out using sorter ,aggregater
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
explain different levels in pushdown optimization with example?
can we override a native sql query within informatica? Where do we do it?
which transformation uses cache?
What is a filter transformation?
How to create Target definition for flat files?