Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

---

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

---

what are cost based and rule based approaches and what is the difference?

1 Answers  

---

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

---

What is the need of etl tools?

0 Answers  

---

how to load duplicate row in a target

4 Answers  

---

how remove 1st 3 records & last 3 records in informatics

4 Answers   TetraSoft,

---

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  

---

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

---

How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 Answers  

---

What is the function of union transformation?

0 Answers  

---

how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 Answers  

---