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

Which is the t/r that builts only single cache memory?

1185

---

what are 3 tech challenges/ common issues you face?

2342

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1954

---

What is substr in informatica?

1200

---

Explain pmcmd command usage in informatica

1122

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2058

---

How to load last n records of file into target table - informatica

1065

---

Performance tuning in UNIX for informatica mappings?

2561

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2129

---

difference between informatica 8.1.1 and 8.6

3673

---

Which are the different editions of informatica powercenter that are available?

1030

---

What's the layout of parameter file (what does a parameter file contain?)?

2381

---

What are the differences between joiner transformation and source qualifier transformation?

1161

---

During the running session, output files are created by informatica server. Enlist few of them.

976

---

What is a sequence generator transformation?

1010

---