Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mahi
Active transformation change the rows that pass through the mapping.
aggregator,filter,sorter,router,source qualifier,transaction control ete.. are active transformations in informatica.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is meant by incremental aggregation?
tell me 5 session failure in real time how can you solve that in your project?
Differentiate between joiner and lookup transformation?
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
my source is junk data how will u remove that junk data by using unix please any one replay me
What is fact table? Explain the different kinds of facts.
Explain the different kinds of facts.
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is xml source qualifier transformation in informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is complex mapping?
Differences between connected and unconnected lookup?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Can we create a Integration service without a Repository service and vice versa?
