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

Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

How union transformation is active ?

2 Answers   Puma,

---

What happens if we dont select data driven option?

2 Answers   Zensar,

---

what is filelist concept in informatica

4 Answers  

---

What are Dimensional table?

0 Answers   Informatica,

---

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  

---

Describe expression transformation?

0 Answers  

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

0 Answers   Informatica,

---

I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers   DELL,

---

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

---

Differentiate between Load Manager and DTM?

0 Answers  

---