Answer Posted / kittu

hi every one

i read all the answers i agree with you but one more thing is there in joiner. once u specify d joiner it will extract all the data from source and check the based on condition then it returns values.

in look up it wont take any values but it refers based on condition.It means look up check the values present r not.
here main thing is memory if cache size is increase it decrease the informatica performance.same thing will happen in joiner trans so mostly we r not using joiner but some times based on source data we use.

scenario where i can use only concurrent execution of workflow.

3255

---

Write the prerequisite tasks to achieve the session partition?

1226

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1185

---

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?

1957

---

What is meant by incremental aggregation?

1179

---

Slowly changing dimensions, types and where will you use them

1767

---

Can we create multiple integration service on single repository?

1240

---

Why filter transformation is an active one?

1031

---

Different circumstance which drives informatica server to expel records?

1040

---

Can u generate reports in Informatica?

1142

---

What is fact table? Explain the different kinds of facts.

1122

---

Does an informatica transformation support only aggregate expressions?

1086

---

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

1137

---

What is difference between a gateway node and worker node?

1200

---

Do you find any difficulty while working with flat files as source and target?

1146

---