Answer Posted / sasikumar_bes

if you have increased your commit interval to ~25000 rows
the session will run faster but when your session fails at
24000th record you will not have any data in your target.

When you decrease your commit interval to ~10000 rows your
session will be slow when compared to previous but if the
session fails at 24000th record you will lose only 4000
records.

How do you convert single row from source into three rows into target?

1090

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7311

---

What is the difference between source qualifier transformations source filter to filter transformation?

994

---

What is meant by active and passive transformation?

1029

---

Explain pushdown optimization and types in informatica

1014

---

Separate from an archive server and a powerhouse?

904

---

How to handle decimal places while importing a flatfile into informatica?

1127

---

What is a code page?

1113

---

What are the different types of repositories created using informatica?

1059

---

what are the deliverables?in your project?

2084

---

What are the popular informatica products?

957

---

what is the Default Source Option For Update Strategy Transformation?

1164

---

How big was your fact table

1743

---

What could be the possible resons of locks by user?

1032

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2507

---