Answer Posted / megha bagaria

Hi Swetha,

Data Quality is when you verify your data and identify if the data present in the warehouse is efficient and error free. The data present in each column should have the meaning full information like it should not have null data, it should not have garbage data, complete correct data must be transformed to the target data, if all the data types are correct as per the requirement, etc.
Asking for Informatica transformations means you want to know how source target tranformations to be implemented in informatica?

Thanks and Best regards,
------------------------------------------------------------
Megha Bagaria | InfoCepts Technologies Pvt Ltd
------------------------------------------------------------

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1715

---

Name the different lookup cache(s)?

713

---

How do you load alternate records into different tables through mapping flow?

1298

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1854

---

How you can differentiate between connected lookup and unconnected lookup?

619

---

---

What are the measure objects?

668

---

How can we handle two sessions in informatica?

619

---

What is event and what are the tasks related to it?

622

---

What is union transformation?

579

---

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

584

---

How can you validate all mappings in the repository simultaneously?

762

---

In how many ways we can create ports?

708

---

Please let me know how to make encryption and decryption with example?

1475

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

3518

---

can u give example for factless fact table

5527

---