What is data quality? How can a data quality solution be implemented into my in

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

Question Posted / swetha

2 Answers
21372 Views
IBM, Wipro, I also Faced
E-Mail Answers

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

how you will maintain version?

3 Answers CTS, TCS,

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers

How to do Integration testing in Informatica?

5 Answers Intelligroup,

What is meant by lookup transformation?

0 Answers

What is difference between maplet and reusable transformation?

2 Answers

Explain sessions and how many types of sessions are there?

0 Answers

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers Eureka Forbes,

How do you join more than 3 flat files in informatica?

1 Answers ITC Infotech,

Briefly define reusable transformation?

0 Answers

can you avoid static cache in the lookup transformation? I mean can you

1 Answers

When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 Answers

I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers

For more Informatica Interview Questions Click Here