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

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?

1042

---

What is the need for an etl tool?

631

---

Explain lookup transformation source types in informatica

694

---

What are the different types of repositories created using informatica?

653

---

How to configure mapping in informatica?

674

---

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1731

---

How can you validate all mappings in the repository simultaneously?

752

---

tell me about your project functionality

1862

---

How many ways are there to create ports?

725

---

What is a predefined event?

656

---

What is data caches/ index caches?

613

---

4 yrs etl devloper roles and responsibilities?any body give solutions

1569

---

what is the difference between informatica6.1 and infomatica7.1

1714

---

Explain sessions?

602

---

Explain why we use partitioning the session in informatica?

607

---