Answer / keerthiravi

The dimension which can be shared more than 1 fact/module called a conformed dimension. Eg: Time dimension

what is Active lock explain

0 Answers   Satyam,

---

there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,

---

what is the gap analysis?

1 Answers  

---

WHat all joins are there in Source Qualifier?

1 Answers  

---

On which transformations you created partitions in your project?

0 Answers   Cap Gemini,

---

Explain the scenario which compels informatica server to reject files?

0 Answers  

---

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  

---

What are the advantages of using informatica as an etl tool over teradata?

0 Answers  

---

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 is meta data and system catalog?

2 Answers  

---

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,

---

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

0 Answers  

---