Answer / 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)

can you use flat file for lookup table?why?

2 Answers   HCL,

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

0 Answers  

---

How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,

---

explan ur project architecture?

0 Answers   TCS,

---

Explain the flow of data in Iinformatica?

1 Answers  

---

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

---

Whats the difference between $, $$, $$$

9 Answers  

---

Briefly describe lookup transformation?

0 Answers  

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   TCS, Wipro,

---

What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers  

---

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  

---

To achieve the session partition what r the necessary tasks u have to do?

1 Answers  

---