Answer / nsatyabrat7

facts are 3 types.

1. Addictive
2. Semi Addictive
3. Non Addictive

Answer / shital.mylove@gmail.com

4 different types of facts
1.Addictive
2.Semi Addictive
3.Non Addictive
4.Factless Fact Table

Answer / thotli

ADDITIVE example is sales
semi additive example is current balance
non additive example is student attendance

what is the diff b/w union and joiner and lookup?

4 Answers  

---

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  

---

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,

---

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

---

can anyone explain me about retail domain project in informatica?

0 Answers   Zensar,

---

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,

---

In ur current projectu have done any performance tuning of mappings?

1 Answers  

---

Whats the difference between $, $$, $$$

9 Answers  

---

connected and unconnected lookups?

4 Answers  

---

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,

---

how can we use sorter transformation in joins?

5 Answers   IBM,

---

What is the difference between a router and a filter transformation?

1 Answers   TCS,

---