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

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 can you increase the performance in joiner transformation?

0 Answers  


When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,


What are the various types of transformation?

0 Answers  


what is the command to get the list of files in a directory in unix?

5 Answers   iGate,


what happens when a batch fails?

3 Answers  






in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,


During the running session, output files are created by informatica server. Enlist few of them.

0 Answers  


what is the use of Data Mart?

5 Answers   IBM,


What do you mean by filter transformation?

0 Answers  


if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,


What are the different types of transformation available in informatica.

0 Answers  


Categories