Answer Posted / sid

you can change the value of a parameter in the mapping.The
new value will be stored in the repository.In case in the
next session run you for some reason fail to define the
parameter in the parameter file informatica will pick up
the last value form the reposiroty

Separate from an archive server and a powerhouse?

485

---

What are the types of caches in lookup?

562

---

How to use pmcmd utility command?

574

---

Explain scd type 3 through mapping.

576

---

What is Data Caches size?

652

---

---

How can you differentiate between powercenter and power map?

613

---

what is diff b/t sorter t/r and agg have the option sorter property...

1733

---

Explain Dataware house architecture .how data flow from intial to end?

2116

---

What is a surrogate key?

555

---

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

3438

---

How do we call shell scripts from informatica?

585

---

Explain what are the different versions of informatica?

651

---

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

1401

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7666

---

What is mapplet in informatica?

588

---