What is aggregate cache in aggregator transforamtion?
Answer Posted / saradhi
aggregate cache is used to aggregate the data for that we
are using data cache.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is meant by LDAP users?
How you can differentiate between connected lookup and unconnected lookup?
What is decode in informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
What is the difference between router and filter?
Whats there in global repository
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is session task and command task?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How does a rank transform differ from aggregator transform functions max and min?
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 substr in informatica?
How to implement security measures using repository manager?