Answer / fajal shaik

Vijayapal reddy

Dimensionality

Answer / adityadeep13

Hi Plz mail me at adityadeep13@gmail.com for Informatica and Tableau training with full installable and interview preparation

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  

---

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,

---

What are the reusable transforamtions?

2 Answers  

---

---

What is Code Page Compatibility?

1 Answers  

---

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,

---

How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,

---

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  

---

Using Expression transformation how to remove duplicate records from a relational source?

4 Answers  

---

What is source qualifier transformation in informatica?

0 Answers  

---

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

---