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 (838)
 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 can we load first and last record from a flat file source to target? ITC-Infotech 6
If a table contains 100 records we have to fetch 50-100 records from source to target?how CSC 5
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid) iFlex 5
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ? Puma 3
what is confirmed dimension?   6
how to join the two flatfiles using the joiner t/r if there is no matching port? Cegedim 5
what are the perameter and variable? IBM 3
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?   3
Types of error logs in Informatica?   2
What is aggregate cache in aggregator transforamtion?   5
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...   1
What are the Differences between connected and unconnected lookup? TCS 6
 
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