Answer / deepthi

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.

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

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.

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 ?

Answer / deepthi

Hi sri,

This is as per my knowledge..........

To answer this question one should undersatnd abt code
pages like unicode data movement,ascii mode data movement
etc.
one byte=8bits

How do you load unique records into one target table and duplicate records into a different target table?

0 Answers  

Explain about Recovering sessions?

1 Answers  

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

how can import the data from the flat files?

2 Answers  

list out all the transformations which use cache?

0 Answers   Informatica,

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

What are the phases in SDLC?

3 Answers  

What is union transformation in informatica?

0 Answers  

What is dynamic cache?

0 Answers  

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers