yesterday my session run ten min.today its run 30min, wt is
the reason? if any issues how to solve that?
Answer Posted / babu
Hi,
As per my knowledge only the reson is the amount of the
source data is too high compare to previous data.
| Is This Answer Correct ? | 14 Yes | 5 No |
Post New Answer View All Answers
list out all the transformations which use cache?
What are the transformations that are not supported in mapplet?
What is fact table? Explain the different kinds of facts.
Write the program through which the records can be updated?
What are the differences between source qualifier and joiner transformation?
How do you set a varible in incremental aggregation
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
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
Can you use flat files in Mapplets.
What is standalone command task?
What is exclusive and normal mode for repository services?
have u done any performance tuning? how u ll do?
What are different types of transformations available in informatica?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How to handle decimal places while importing a flatfile into informatica?