Answer / suresh

2008

According to his methodology what all you need before you build a datawarehouse

0 Answers  

---

How can yoU create or import flat file definition in to the warehouse designer?

2 Answers  

---

why we use datawarehouse

0 Answers   HCL,

---

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

---

surrogate keys usage in Oracle and Informatica?

5 Answers   ITC Infotech, Oracle,

---

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,

---

please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

---

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,

---

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

---

What is the difference between procedure and stored procedur?

2 Answers   IBM,

---