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 |
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
What does “tail –f” command do and what is its use as an Informatica admin.
How to load the data from people soft hrm to people soft erm using informatica?
"Change cache" in Informatica ?
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
How can we get multiple output values using an unconnected lookup transformation?
Whats there in global repository
How to handle changing source file counts in a mapping?
What do you mean by channel change?
In how many ways we can create ports?