Answer Posted / gyana
data driven is the session property.which tell the is to do
the operations on data as per the update strategy
transformation used in mapping..
it also defines that multiple database operations are done
in database(like insert,delete etc..
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to load dimension table and fact table. plz tell me the steps.
What is enterprise data warehousing?
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
Briefly define reusable transformation?
What are the uses of etl tools?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is a predefined event?
Define filter transformation?
What is an unconnected transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
How to do the error handling of if ur source is flatfiles?
Where do we use mapping variables in informatica?
Why do you use Mapping Parameter and mapping variable?
How to elaborate tracing level?
While migrating the data from one environment to another environment how would you manage the connections?
