Answer Posted / sachin

1.It is also not allow the constraint when we make Target load type as Bulk Mode
2.Also we do not allow to use indexes on database level in Bulk mode But in Normal mode we can allow indexes as well as constraint.

Which transformation is needed while using the Cobol sources as source definitions?

1154

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1789

---

write a query to retrieve the latest records from the table sorted by version(scd)

1049

---

What is the use of target designer?

1021

---

What is data transformation manager process?

1131

---

What are mapplets? How is it different from a Reusable Transformation?

1069

---

how we can load rejected record's at run time?(not through bad files)

2355

---

What is the difference between source qualifier transformations source filter to filter transformation?

1031

---

How might one distinguish in the case of mapping is right or not without associating session?

1079

---

What are the advantages of using informatica as an etl tool over teradata?

1008

---

What does reusable transformation mean?

1116

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1178

---

What is a dimensional model?

962

---

What are the types of caches in lookup? Explain them.

952

---

Explain the etl program with few examples.

1028

---