Answer / urs

1) Following are the some of bottlenecks in informatica..

(i) source bottlenecks
(ii)Target bottlenecks
(iii)Mapping bottlenecks
(iv) system bottlenecks

3)Informatica is one of most popular ETL tool...it will extract the data from the different sources and it will transform the data as per business logic and then it will load the data into different targets..

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

---

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

---

who is the best faculty for informatica in hyderabad ameerpet?

1 Answers  

---

What is a surrogate key?

0 Answers  

---

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 Answers  

---

what are 3 tech challenges/ common issues you face?

0 Answers   TCS,

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers   Informatica,

---

how can u approach u r client

2 Answers   CTS,

---

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

---

Enlist the tasks for which source qualifier transformation is used.

0 Answers  

---

how you will maintain version?

3 Answers   CTS, TCS,

---