Answer Posted / sam

Run the infacmd ConvertLogFile -in <inputfilename> -lo
<outputfilename>. This batch file is present in
\\Informatica\PowerCenter8.6.1\CMD_Utilities\PC\server\bin

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1947

---

State the differences between sql override and lookup override?

1136

---

Explain how to import oracle sequence into informatica?

968

---

What are the new features of Power Center 5.0?

1721

---

How do you migrate data from one environment to another?

1062

---

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

1821

---

what is unit testing?tell me proceedure

2181

---

What do you mean by enterprise data warehousing?

1018

---

What is meant by pre and post session shell command?

1118

---

What do you understand by SOA of Informatica?

944

---

What is meant by a domain?

1092

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1994

---

How would you join a node to the already existing domain?

1083

---

How big was your fact table

1762

---

What is the scenario which compels informatica server to reject files?

1024

---