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)

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,

---

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  

---

diffrence between command task and control task

1 Answers   iNautix,

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

---

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  

---

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

---

How can we delete duplicate rows from flat files?

0 Answers  

---

can we override a native sql query within informatica? How do we do it?

0 Answers  

---

in static and dynamic which one is better

2 Answers  

---

Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,

---

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  

---

Diff b/w ShortCut and reusabel Object ?

4 Answers  

---