Answer / babu

Hi,

In informatica 8.6.0 has one most usefull feature i.e
is nothing but a PUSHDOWN OPTIMISATION.This is available in
session properties.whenever the client want beter
performance that time we use this feature.

basically pshdown optimisation classified into 3 seps.
1.Sourece side pushdown optimisation.
2.Target side pushdown optimisation.
3.Full based pushdown optimisation.

1.Sourece side pushdown optimisation::
It means topush the
busines logic into source database(RDBMS ONLY)as much as
Possible.It reducess the burden of the informatica server
to run the session.

2.Target side pushdown optimisation::
It means topush the
busines logic into Target database(RDBMS ONLY)as much as
Possible.It reducess the burden of the informatica server
to run the session.
3.Full based pushdown Optimisation::
It means topush the
busines logic into Source,Target database(RDBMS ONLY) and
Informatica as much as Possible.It reducess the burden of
the informatica server to run the
session.
NOTE: The above all are work only the RDBMS files only
only.

please correct me if any thing wrong.

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

---

One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?

2 Answers  

---

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,

---

how do u move the code from development to production?

6 Answers  

---

How many number of sessions that u can create in a batch?

3 Answers  

---

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

---

In warehouses how many schemas are there?

0 Answers  

---

what is parallel querying and what r hints.

1 Answers  

---

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

---

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

---

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

1 Answers   IBM,

---

"Change cache" in Informatica ?

2 Answers  

---