In update strategy target table or flat file which gives
more performance ? why?
- 7 Answers
- 23631 Views
- I also Faced
- E-Mail Answers
Answer Posted / sriram
Update strategy can be performed on tables not on Flat files.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a stored procedure transformation?
In development project what is the process to follow for an etl developer from day1
What is Session and Batches?
How do you migrate data from one environment to another?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what is degenerated dimension?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Explain the features of connected and unconnected lookup.
How would you copy the content of one repository to another repository?
Difference between Target-based loading and constraint-based loading?
Sequence generator, when you move from develoment to production how will you reset
my source is junk data how will u remove that junk data by using unix please any one replay me
What is flashback table ? Advance thanks
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
