Answer Posted / venkateshmalneni

files are better in performance than database.
because database has to connect to the odbc,and some drivers to extract or load the data.
But in case of file we directly extract or load the data.so,as per the performance files are better

How to Create a folder using pmrep command?

1173

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1264

---

Where do we use mapping variables in informatica?

1065

---

list out all the transformations which use cache?

1184

---

What do you understand by a term domain?

1125

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1946

---

How can you differentiate between powercenter and power map?

1089

---

How can we use batches?

1025

---

What are the databases that informatica can connect to windows?

1052

---

What is the benefit of partitioning a session?

1182

---

explain abt ur project architecture?

2194

---

How identifying bottlenecks in various components of informatica and resolving them?

1132

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1267

---

Explain the mapping variable usage example in informatica

1158

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2158

---