Answer Posted / ankit kansal

Three ways to achieve the result..

1) Sorter Transformation (Distinct Oprtion)
2) Aggregator Transaformation (Group by ALL PORTS)
3) Rank Transformation (Group by ALL) and RNK=1


http://deepinopensource.blogspot.in/

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2452

---

What is joiner transformation?

1008

---

Explain the tuning lookup transformation - informatica

988

---

Difference between Data and Index Caches?

1137

---

What is transformation?

1099

---

What is the difference between a connected look up and unconnected lookup?

964

---

In informatics server which files are created during the session rums?

1112

---

Define update strategy?

1219

---

What are the prerequisite tasks to achieve the session partition?

1250

---

What is a difference between complete, stop and abort?

1083

---

What is the maplet?

1118

---

Can we get 1st record through Informatica(without sequence number).

1479

---

what is the size of your data warehousing?

2093

---

What are the types of schemas we have in data warehouse and what are the difference between them?

939

---

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

9121

---