Answer Posted / rayudu

There are two types of error logs
1.Relational error logs.
2.File Error logs.

Rgds,
rayudu

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

1062

---

Can we create a Integration service without a Repository service and vice versa?

1170

---

Does an informatica transformation support only aggregate expressions?

967

---

What could be the possible resons of locks by user?

1032

---

Explain the types of transformations?

1004

---

What is a dimensional model?

926

---

How you prepared reports for OLAP?

1545

---

generate date / time dimension in informatica

1066

---

how tokens will generate?

2152

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2075

---

Explain the different lookup methods used in informatica?

972

---

What is session task and command task?

1174

---

Design a mapping to load a target table with the following values from the above source?

1283

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

913

---

Can we create multiple integration service on single repository?

1131

---