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
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 |
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 |
if i am having 10 records in source, i want 20 records in target...how will you do it
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to read data from flat file source if the data is in paragraph format?
How do you update the records with or without using update strategy?
How to import oracle sequence into Informatica?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
What are the types of groups in Router transformation?
Which is the t/r that builts only single cache memory?
What is a predefined event?
How to display null values on a target & non-null values on a target?
How to handle changing source file counts in a mapping?