how to obtain performance data for individual
transformations.

Answers were Sorted based on User's Feedback



how to obtain performance data for individual transformations...

Answer / vasu

There is a property at session level "Collect performance
data", you can select that property. It gives you
performance details for all the transformations.

Is This Answer Correct ?    10 Yes 0 No

how to obtain performance data for individual transformations...

Answer / ram

Just by selecting "Verbose" mode in session properties.

then session log contains detaild information about each
and every transformation involved in the mapping

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 Answers  


Why is sorter an active transformation?

0 Answers  


How do you load first and last records into target table?

0 Answers  


Explain the types of transformations?

0 Answers  


what is the difference between stop and abort?

3 Answers   TCS,






can we use self join in informaitca?

3 Answers   IBM,


how to we create datamart?

2 Answers   HSBC,


i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.

3 Answers  


-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?

1 Answers   TCS,


What is target designer and target load order?

0 Answers  


What is lookup transformation?

0 Answers  


CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

4 Answers   CSC,


Categories