Answer / swetha

For a relational sources informatica server creates multiple
connections for each parttion of a single source and
extracts seperate range of data for each connection.
Informatica server reads multiple partitions of a single
source concurently. Similarly for loading also informatica
server creates multiple connections to the target and loads
partitions of data concurently.

For XML and file sources,informatica server reads multiple
files concurently. For loading the data informatica server
creates a seperate file for each partition(of a source
file).U can choose to merge the targets.

Explain about HLD and LLD ?

16 Answers   Accenture,

---

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

---

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  

---

What are the uses of etl tools?

0 Answers  

---

What is factless fact schema?

1 Answers  

---

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

---

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,

---

What are the new features of informatica 9.x developer?

0 Answers  

---

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,

---

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,

---

Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,

---

How to jion 2 tables, without using any condition?

11 Answers   Amazon,

---