Answer Posted / abhinaw prakash

Just to add on the above points.We cannot decide which
transofrmation logic to send to the Database.The
integrations service decides which login to send to the
database to optimize the process.although we can see the
sql logic in the Pushdown priview and the messages and
warning attached to it.

What is substr in informatica?

1256

---

What are the different types of repositories created using informatica?

1168

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

2026

---

What is the sequence generator transformation in informatica?

1259

---

What are data-driven sessions?

1257

---

Different circumstance which drives informatica server to expel records?

1037

---

What is expression transformation?

1142

---

What are the popular informatica products?

1054

---

What are the modules in Power Center

1716

---

How to update source definition?

1138

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4244

---

Explain incremental aggregation in informatica

1180

---

How many numbers of sessions can one group in batches?

1101

---

How can we update a record in the target table without using update strategy?

1199

---

How to update or delete the rows in a target, which do not have key fields?

1217

---