In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
Answer Posted / ramu
The column which is used as a key prot in sorter should be
the group by port and check box sorted input in aggregator
t/r properties
Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What is aggregator transformation in informatica?
How are indexes created after completing the load process?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Briefly define reusable transformation?
Explain the mapping variable usage example in informatica
Why filter transformation is an active one?
How you prepared reports for OLAP?
What is confirmed fact in dataware housing?
How to create or import flat file definition in to the warehouse designer?
What are the different components of powercenter?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What do you mean by worklet?
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
Describe the impact of several join conditions and join order in a joiner transformation?
What is exclusive and normal mode for repository services?