can u give example for factless fact table

2 Answers   TCS,

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  

---

What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,

---

How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,

---

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

---

Did u used latest transformations of 8.6.0? for what?

0 Answers  

---

what happens when a batch fails?

3 Answers  

---

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---

What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,

---

Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  

---

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

---

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

---