Answer Posted / dharmendra

Hi Mahesh,
This is not the right place to do marketting.
Here we share our technical issues and resolve the same.
There are many other ways to attract people for your
institue.
Please do not repeat such malfunctioning.

What are the various types of transformation?

1097

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1026

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

952

---

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

1988

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2142

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1038

---

What is native users?

1102

---

How does the aggregator transformation handle null values?

1087

---

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

1808

---

Which are the different editions of informatica powercenter that are available?

972

---

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

2435

---

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

1928

---

Differentiate between joiner and lookup transformation?

1049

---

What are the informatica performance improvement tips

1019

---

What is meant by target load plan?

916

---