any body can say about all versions of informatica ?how
many versions ?
Answer Posted / rahul
6.X, 7.X, 8.X and 9.X
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is the difference between informatics 7x and 8x and what is latest version?
what is the size of your data warehousing?
Explain Dataware house architecture .how data flow from intial to end?
What are the uses of etl tools?
write a query to retrieve the latest records from the table sorted by version(scd)
if we have a delimiters at unwanted places in a flat file how can we over come those.
How can we handle two sessions in informatica?
can u give example for factless fact table
What is the difference between router and filter?
Describe an informatica powercenter?
What is olap (on-line analytical processing?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is a repository manager?
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
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.