Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / giri
Tranformation is extract data from one data to another data base in condition,
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are some examples of informatica etl programs?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is status code in informatica?
what is SDLC way of code development?
Do you find any difficulty while working with flat files as source and target?
In how many ways we can create ports?
What is an active transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
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
How to load data in informatica ?
What is dynamic cache?
Define mapplet?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Can we change Dynamic to Static or Persistent cache? If so what happens?
