Answer Posted / gyana ranjan behera

SESSION LEVEL PERFORMANCE TUNING

(1)SET YOUR SESSION TO RUN IN BULK MODE
(2)DO SESSION PARTITION
(3)INCREASE COMMIT INTERVALS
(4)CHECK THE INCREMENTAL AGGREGATION
(5)DTM BUFFER SIZE MUST BE IN BETWEEN 6MB TO 128MB
(6)BUFFER BLOCK SIZE 4KB TO 128KB

wf dont have integration severances how you can run?

1891

---

Mention a few design and development best practices for informatica?

946

---

Design time, run time. If you don't create parameter what will happen

1803

---

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?

1625

---

Briefly define reusable transformation?

1083

---

list out all the transformations which use cache?

1129

---

pmscmd startworkflow -sv -d -u -p -f 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?

1456

---

where to store informatica rejected data? How to extract the informatica rejected data?

962

---

how tokens will generate?

2163

---

Explain load alternative records / rows into multiple targets - informatica

1112

---

Which transformation should we use to normalise the COBOL and relational sources?

1151

---

scenario where i can use only concurrent execution of workflow.

3087

---

Write the advantages of partitioning a session?

1223

---

design of staging area?

1978

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1031

---