what is difference between dimention table and fact table?

1 Answers  

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

Why we need XMLs?

3 Answers   IBM,

---

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

---

---

star and snowflake schema?

6 Answers  

---

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,

---

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

---

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers   HCL, Schneider,

---

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

---

How to load last n records of file into target table - informatica

0 Answers   Informatica,

---