Answer Posted / ankur saini

sol--seq gen---rank ---filter

add a sequence generator ...

ex input is
1 a
1 b
2 a
2 b
after seq generator
1 a 1
1 b 2
2 a 3
2 b 4

then ranl it group by all file ports rank on the seq gen key
input seq rank
1 a 1 1
1 b 2 2
2 a 3 1
2 b 4 2

add filter on rank=1

enjoy!!!!!

What differs when we choose the sorted input for aggregator transformation?

969

---

According to his methodology what all you need before you build a datawarehouse

1691

---

draw informatica architecture 8.6 ?

3822

---

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

8946

---

What are the new features of informatica 9.x in developer level?

941

---

How to differentiate between the active and passive transformations?

1078

---

Different circumstance which drives informatica server to expel records?

918

---

What is joiner transformation in informatica?

995

---

Explain what transformation and how many are there in informatica?

891

---

What is status code in informatica?

960

---

Explain what are the different types of transformation available in informatica.

1039

---

What are connected or unconnected transformations?

1051

---

How many transformations can be used in mapplets.

1874

---

Explain the types of lookup transformation?

979

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1067

---