1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What is data quality? How can a data quality solution be
implemented into my informatica transformations, even
internationally?

Question Posted / swetha

Answers were Sorted based on User's Feedback



What is data quality? How can a data quality solution be implemented into my informatica transforma..

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

Is This Answer Correct ?    1 Yes 0 No

What is data quality? How can a data quality solution be implemented into my informatica transforma..

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.


Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Informatica Interview Questions

what is casual dimension?

6 Answers   IBM,

4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,

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

1 Answers   Accenture,

can anyone explain me about retail domain project in informatica?

0 Answers   Zensar,

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,




hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  

What is dimensional table? Explain the different dimensions.

0 Answers  

How to load a Dimension ? and how to load a fact table?

0 Answers  

What is the maplet?

0 Answers   Informatica,

How to merge First Name & Last Name?

8 Answers  

what is galaxy repository?

2 Answers  

suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer

1 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories