Answer Posted / yaseen

Rowid of view and table is same
Rowid of M.view and table is different

What is workflow? What are the components of the workflow manager?

1146

---

Explain how many types of dimensions are available in informatica?

1101

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1082

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1631

---

What is the Process to creating lookup transformation in informatica

1048

---

What is meant by active and passive transformation?

1131

---

Different sorts of metadata that stores in the storage facility?

1018

---

How to join three sources using joiner? Explain though mapping flow.

1152

---

What is substr in informatica?

1213

---

What is enterprise data warehousing?

1053

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1285

---

Explain constraint based loading in informatica

1103

---

Does an informatica transformation support only aggregate expressions?

1049

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1272

---

What is target designer and target load order?

1112

---