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

Answer / srinu

Data wili have Special characters,Symbols,Nulls,Zeros,,,
You need Cure the Data using Default values,Null
updates,,,like many things r there,,
In Inf trans Avoid the nulls,Correct DataType with
Length,Unique data,,,,like,,many ways u can cure the data.

In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,

---

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,

---

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

---

What is the difference between view and materialised view?

6 Answers  

---

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  

---

---

What is query panel?

1 Answers  

---

what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,

---

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

5 Answers   Patni,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,

---

what is the size of u r project? and what is the size of source file?

1 Answers   HP,

---

What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,

---