Answer Posted / prathibha

Hi,

Source->SQ->Sorter->Expression->FilterTarget.
Lets take a small example for this scenario.
Use a sorter to sort the input data.
ID Name
1 A
1 A
2 B
3 C
3 C

In Expression Transformation declare the following ports:

ID
Name
O_Count= iiF(V_port=ID,O_Count=O_count+1,O_Count=0)
V_port(Variable Port) = ID;

In filter transformation give the condition O_Count =0;
Let me know if there are any suggestions.

What all join we can perform in LOOKUP transformation?

928

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2152

---

What is informatica?

1088

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2341

---

What is meant by lookup transformation?

1049

---

What is enterprise data warehousing?

996

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2074

---

How do you load unique records into one target table and duplicate records into a different target table?

1178

---

What is the command used to run a batch?

1009

---

Enterprise data warehouse your projects phase by phase explain?

1869

---

Explain what transformation and how many are there in informatica?

899

---

What is olap (on-line analytical processing?

1021

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2305

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7340

---

Why union transformation is an active transformation?

1003

---