Answer Posted / chandrasekar

Hi Amarnath,

Your answer is to import the .doc,pdf file format files into
informatica but how we can convert .doc into .txt.Bacause
the above question is converting?

Can u please explain?????

Please mail me chandranmca2007@gmail.com

Why update strategy and union transformations are active?

1036

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1089

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1660

---

In how many ways we can create ports?

1115

---

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,

7177

---

How does a sorter cache works?

1062

---

How can we use batches?

1022

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

1074

---

Explain the aggregator transformation?

1152

---

What is meant by query override?

1055

---

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 is rank index in rank transformation?

1070

---

In informatics server which files are created during the session rums?

1112

---

What do you understand by term role-playing dimension?

1042

---

Describe the impact of several join conditions and join order in a joiner transformation?

1057

---