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 |
Explain how to import oracle sequence into informatica?
When the informatica server marks that a batch is failed?
what is distinct
How to display First letter of Names in Caps?
What is A cache?
How to update a particular record in target with out running whole workflow?
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
Describe expression transformation?
What is lookup transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How many dimensions are there in informatica?
Howmany ways yoU can update a relational source defintion and what are they?