Answer / vas.chiky

They are present in OBIEE analytics application. Not in
informatica.

They are pages containing various reports.

say, sales dashboard contains annual salaes report.
location wise sales. profit and loss of current month.

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

---

What are the ETL tools available in DWH?

6 Answers   Mphasis,

---

What is source qualifier transformation in informatica?

0 Answers  

---

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,

---

What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  

---

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

3 Answers   Cognizant, Flextronics,

---

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

---

In operator is used in which transformation in informatica 8.6.0

5 Answers   Virtusa,

---

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

---

what is the size of ur database(like oracle)

2 Answers   HP,

---

hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  

---