Answer Posted / ali

if u config wrong relational coonnections in workflow manager, session failed.




2)if u enable bulk load without droping indexes in tgt table, run a session  the session get failed.




3)in workflow manager eventwait task waiting for particular time, then the indicator(file) not found, session get failed.




4)while sql override in s.q t/r,u miss any func in query, then (mapping valids) session failed? write  correct sql and execute it session succeess.




5)the tgt table has pk , but u r loading duplicated data  then session get failed( note:when u put 0 for "stop on errors" property it allows any number of non fatal errors)

How are indexes created after completing the load process?

1541

---

In informatica workflow manager, how many repositories can be created?

1263

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2060

---

Explain the aggregator transformation?

1090

---

explain one complex mapping with logic? sales project?

6590

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1976

---

what are the Methods For Creating Reusable Transformations?

1098

---

Define mapping and session?

966

---

What are the types of schemas we have in data warehouse and what are the difference between them?

887

---

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

1118

---

What are the static cache and dynamic cache in informatica?

1138

---

What is different between the data warehouse and data mart?

1000

---

What is informatica worklet?

984

---

Explain the scenario which compels informatica server to reject files?

1086

---

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

1026

---