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 |
how to get the first row without using rank t/r?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
Why union transformation is an active transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is a test load?
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
Can we change Dynamic to Static or Persistent cache? If so what happens?
Scheduling properties,whats the default (sequential)
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
What is parameter file?
difference between source based commit? and target based commit? which is better with respect to performance?