Answer Posted / raji

Hai frnds,
According to my knoweledge,active t/f means which changes the number of rows that can pass through it.
coming to why union t/s is active.......because union t/f merges the data which is coming from two sources,it means that it summarizes the data which is passing through union t/f,with this the no.of rows coming from that will be less....
so it is an active t/f...

Thanks.....Raji

What is session task and command task?

1305

---

how to create user defined function (udf) in informatica

1315

---

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

946

---

Why do we need informatica?

1002

---

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

1867

---

What is native users?

1174

---

Quickly characterize reusable change?

1126

---

have u done any performance tuning? how u ll do?

2299

---

How to start a workflow using pmcmd command?

1256

---

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?

2268

---

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

4167

---

Partition, what happens if the specified key range is shorter and longer

2502

---

Design time, run time. If you don't create parameter what will happen

1837

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2013

---

What is option by which we can run all the sessions in a batch simultaneously?

1149

---