What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

Please let me know how to make Data masking in informatica..

0 Answers  

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

0 Answers  

---

What is the difference between view and materialised view?

4 Answers  

---

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  

---

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

---

What are different types of transformations available in informatica?

0 Answers  

---

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

4 Answers   CSC,

---

Why is sorter an active transformation?

0 Answers  

---

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

---

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  

---