Answer / ranjan

Sql only allow us to join only two tables at a time because intersection/union methodology can only possible in two tables .

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,

---

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

0 Answers  

---

What is a repository manager?

0 Answers  

---

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  

---

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...

0 Answers  

---

When to use normalization transformation other than cobol source?

2 Answers  

---

Can you copy the batches?

3 Answers  

---

task is running successfully but data is not loded why?

2 Answers  

---

Explain the difference between a data warehouse and a data mart?

0 Answers  

---

which one is better performance wise joiner or look up

0 Answers   Informatica,

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

---