Answer Posted / anand kumar

(total number of sources + total number of targets)* 2] =
(session buffer blocks)

(session Buffer Blocks) = (.9) * (DTM Buffer Size) /
(Default Buffer Block Size) * (number of partitions)

Describe data concatenation?

1085

---

What all join we can perform in LOOKUP transformation?

981

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1907

---

explain about unit testing? in real time?

2209

---

What do you mean by blocking transformation?

1044

---

What are the different clients of powercenter?

1063

---

Explain pushdown optimization and types in informatica

1080

---

How to generate sequence numbers using expression transformation?

1094

---

What happens when a session fails and you click on recover?

1121

---

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?

1512

---

Explain the aggregator transformation?

1169

---

What is native users?

1170

---

waht type of interface is used for testing the data in informatica

2259

---

What are some examples of informatica etl programs?

944

---

How do you update the records with or without using update strategy?

1118

---