Answer / gaurav

Unit testing is a process where u would be testing ur
application or mapping by taking sample data to check if it
satisfies the business rules.

Answer / sri ram

You can do unit testing by testing your mapping
1.develop the mapping,take target as a .csv file(if the
target db location is remote)
2.give some input satisfying business rules
3. check whether the output is generated appropriately

Answer / shaik

Unit Testing is one of the testing process to provide some
sample data (hard coded data some times) to ensure your
logic is working as expected.
Talking Unit Testing specific to Informatica this is how I
did :
1. Generate a reference table from a .csv file on
Informatica Analyst.
2. Generate a profile using this Reference table( when ever
a reference table is creared a corresponding sql table is
created in the provided db during configuration)
3. Apply your rule (mapplet) on your profile and check if
you get the expected results.
4.You can add /remove data in the reference table to check
various scenarios.

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,

---

what are the differences between powercenter 8.1 and powercenter 8.5?

2 Answers  

---

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

---

 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,

---

What do you mean by enterprise data warehousing?

0 Answers  

---

scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,

---

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  

---

Design a mapping to get year of join for each employee.

4 Answers   Accenture,

---

how to run the batch using pmcmd command

2 Answers   Wipro,

---

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 Answers   TCS,

---

Which is better performance wise database or file?How?

2 Answers   TCS,

---

How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

1 Answers   Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,

---