Answer Posted / adisekhar

->->UPS->TAR
MAPPING DIAGRAM LIKE SRC->SQL->RTR->
->UPS->TAR

How to load last n records of file into target table - informatica

1050

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1937

---

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

1072

---

What is blocking transformation?

1124

---

How can we remove the duplicates from flat file source?

997

---

Can you use flat files in Mapplets.

2639

---

What is flashback table ? Advance thanks

1917

---

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

1836

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7352

---

Can anyone tell me the new features in Informatica 9 Version?

2103

---

What is mapping debugger?

987

---

How to generate sequence numbers using expression transformation?

1072

---

How union transformation is used?

989

---

Explain the different dimensions.

943

---

What are the new features of Power Center 5.0?

1752

---