Answer Posted / praneeth

Dear Sudheer,

Whatever you said is right. But the size you mentioned is
only for 'ORACLE' database.Different databases have
diferent sizes.
Rest all is fine.

Can u give your mobile number ?

can we override a native sql query within informatica? Where do we do it? How do we do it?

1047

---

How to load the data from people soft hrm to people soft erm using informatica?

1008

---

How many ways are there to create ports?

1327

---

What is data transformation manager process?

1151

---

Why update strategy and union transformations are active?

1038

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1951

---

What is lookup transformation?

1038

---

What is a dimensional model?

977

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2302

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7182

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1161

---

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

994

---

Briefly describe lookup transformation?

1044

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2123

---

What are ETL Tools?

1111

---