Answer Posted / 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.

Can u generate reports in Informatica?

1024

---

Explain the tuning lookup transformation - informatica

949

---

generate date / time dimension in informatica

1065

---

What are Dimensional table?

997

---

Name the different lookup cache(s)?

1156

---

Explian the Process of deployment groups in informatica

988

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1884

---

Design a mapping to load a target table with the following values from the above source?

1282

---

What are ETL Tools?

1039

---

what is Active lock explain

2723

---

What is native users?

1098

---

can you please explain me pre session and post session options?

7394

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1093

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1131

---

What are the informatica performance improvement tips

1016

---