ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Data Warehouse >> Informatica
 
 


 

 
 Teradata interview questions  Teradata Interview Questions (178)
 Business Objects interview questions  Business Objects Interview Questions (750)
 Cognos interview questions  Cognos Interview Questions (836)
 Informatica interview questions  Informatica Interview Questions (1617)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (168)
 Data Stage interview questions  Data Stage Interview Questions (562)
 SAS interview questions  SAS Interview Questions (549)
 Micro Strategy interview questions  Micro Strategy Interview Questions (35)
 ETL interview questions  ETL Interview Questions (193)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (214)
Question
What is data quality? How can a data quality solution be
implemented into my informatica transformations, even
internationally?
 Question Submitted By :: Swetha
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?
Answer
# 1
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 2 No
Srinu
 
  Re: What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?
Answer
# 2
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 ?    0 Yes 0 No
Megha Bagaria
 
 
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
How to improve the performance of Aggregate transformation? Dmss 3
where actually the usage of push down optimization happens...   2
Hey I am net to informatica? Can any one explain me step by step How scd will work ? Infosys 1
What is CDC? How to implement CDC? TCS 3
What is router transformation CSC 3
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000 IBM 5
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!   2
THREE DATE FORMATS R THERE . HOW TO CHANGE THESE THREE INTO ONE FORMAT WITHOUT USING EXPRESSION TRANSFORMATION ? HP 2
what is the process we used in joiner transformation,there is no matching column in sources?   2
What is the Router transformation?   2
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80 iGate 3
what is upstream and downstream transformation?   7
 
For more Informatica Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com