Interested to Buy Any Domain ? << Click Here >> for more details...
Without using any transformations how u can load the data into
target?
- 15 Answers
- 25082 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sree
at the time of draging source in to workspace it will auto
matically genartes sq t/r from this u connect to target
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Explain direct and indirect flat file loading (source file type) - informatica
How to start a workflow using pmcmd command?
Explain joiner transformation in informatica
What is the fact table?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What does cheating measurement mean?
What is exclusive and normal mode for repository services?
Quickly characterize reusable change?
Plz can any one say me how to get the informatica certification materials and dumps
How to create a non-reusable instance of reusable transformations?
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
What is option by which we can run all the sessions in a batch simultaneously?
can u any challenge your project?
How do you load only null records into target? Explain through mapping flow.
What you know about transaction control transformation?
