how to obtain performance data for individual
transformations.
Answers were Sorted based on User's Feedback
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 |
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 |
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..?
Why is sorter an active transformation?
How do you load first and last records into target table?
Explain the types of transformations?
what is the difference between stop and abort?
can we use self join in informaitca?
how to we create datamart?
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.
-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?
What is target designer and target load order?
What is lookup transformation?
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