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.

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

---

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,

---

why u go for dimensions ?

3 Answers   TCS,

---

In joiner, how to load Master table in Target?

2 Answers  

---

Please let me know how to make encryption and decryption with example?

0 Answers  

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,

---

pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,

---

What is a rank transform?

0 Answers  

---

Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  

---

server hot-ws270 is connect to Repository B. What does it mean?

0 Answers   Cognizant,

---

What is the difference between a router and a filter transformation?

1 Answers   TCS,

---

when we use dynamic lookup,if condition matches what will be the o/p?

2 Answers   L&T,

---