Answer / dr.jornalist

Informatica server rejects records beasuse of mainly 2
reasons

1) When there are database constraints
2) When the data gets overflowed

Answer / bsgsr

also when the update strategy contains dd_reject

what is DSS?

3 Answers  

---

which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,

---

What is the benefit of partitioning a session?

0 Answers  

---

How can you recover the session in sequential batches?

1 Answers  

---

Can we update the data in flat file using update strategy?

3 Answers  

---

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

---

1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,

---

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  

---

Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,

---

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

---

Explain grouped cross tab?

1 Answers   Accenture,

---

what is the difference between static and dynamic

4 Answers   TCS, Wipro,

---