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.

What do you mean by blocking transformation?

1044

---

What is the format of informatica objects in a repository?

1021

---

What is an Integration service in Informatica?

1136

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1679

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1113

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1285

---

Explain about cumulative Sum or moving sum?

1044

---

where to store informatica rejected data? How to extract the informatica rejected data?

1007

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1641

---

What is decode in informatica?

1166

---

What are the different types of transformation available in informatica.

1105

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1933

---

What do you mean by channel change?

1051

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1905

---

generate date / time dimension in informatica

1128

---