Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pradosh
this is a stupid Question,
informatica is a ETL tool which is extract,transfoemation,and load data from source to target,bcz our project based on informatica tool so we used
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How to update or delete the rows in a target, which do not have key fields?
How might you approve all mappings in the archive all the while?
What is the commit type if you have a transaction control transformation in the mapping?
What is a snowflake schema?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is a repository? And how to add it in an informatica client?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is the use of transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
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
Mention few advantages of router transformation over filter transformation.
Clarify the aggregator change?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is informatica etl tool?
what is Active lock explain
