Answer Posted / ahalya inturi
target load plan defines order in which data extracted from
source qualifier transformation
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is a connected transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
what are 3 tech challenges/ common issues you face?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How to elaborate tracing level?
What is a joiner transformation and why it is an active one?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is a router 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
To import the flat file definition into the designer where should the flat file be placed?
What is the function of union transformation?
What is target designer and target load order?
Which files are created during the session rums by informatics server?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com