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 |
Explain what are the different versions of informatica?
How can a transformation be made reusable?
can we see default group,when we use router?if yes how?
How many joins in Informatica
can we use mapplet as starting n ending object in mapping
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
What is olap (on-line analytical processing?
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc