In a scenario I want to change the dimensions of a table and
normalize the denomralized table which transformation can I use?
Answer Posted / hemanth
use joiner.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is rank transform?
What is meant by incremental aggregation?
What is powercenter on grid?
Can we create two repositories on same database instance in oracle?
Clarify the utilization of aggregator cache record?
define galaxy repository in informatica
COM components can be used in Informatica
Why union transformation is an active transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is workflow manager?
What are the mapping parameters and mapping variables?
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 data caches/ index caches?
What is the cumulative sum and moving sum?
What are the limitations of joiner transformation?