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 can you increase the performance in joiner transformation?
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
What are the various types of transformation?
what is the command to get the list of files in a directory in unix?
what happens when a batch fails?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
During the running session, output files are created by informatica server. Enlist few of them.
what is the use of Data Mart?
What do you mean by filter transformation?
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
What are the different types of transformation available in informatica.