Answer Posted / ojesh

First do a count of the records in the file using a wc -l unix command, store that number in a variable.

create a counter in an expression and increment it with every icoming record.

create a router after that and route if the counter is less than half to target 1 else target 2.

What are the tasks that can be performed using sq?

1093

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2263

---

can we override a native sql query within informatica? How do we do it?

1126

---

During the running session, output files are created by informatica server. Enlist few of them.

982

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1864

---

What is meant by query override?

1061

---

How many ways a relational source definition can be updated and what are they?

1017

---

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4727

---

can u any challenge your project?

2033

---

r u done any partitions in ur project?

1827

---

What is a snowflake schema?

996

---

What is the advantage of informatica?

1069

---

What happens when a session fails and you click on recover?

1120

---

What are the tuning techniques you applied during your last project

2026

---

What is aggregate cache in aggregator transformation?

1145

---