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.

All active transformations r passive or not?

7 Answers  

---

COM components can be used in Informatica

0 Answers  

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

0 Answers  

---

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

---

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,

---

"Change cache" in Informatica ?

2 Answers  

---

How many repositories can we create in Informatica?

3 Answers  

---

How do you load alternate records into different tables through mapping flow?

0 Answers  

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

What is flashback table ? Advance thanks

0 Answers   Puma,

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,

---