What are the different types of repositories created using informatica?

0 Answers  

---

can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,

---

How will you convert rows into columns or columns into rows

1 Answers  

---

How union transformation is active ?

2 Answers   Puma,

---

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,

---

what is the use of Data Mart?

5 Answers   IBM,

---

what is a time dimension? give an example?

2 Answers   IBM,

---

What are the types of metadata that stores in repository?

2 Answers  

---

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,

---

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

---

why union is active transformation?

4 Answers   IBM,

---

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,

---