What is data quality? How can a data quality solution be
implemented into my informatica transformations, even
internationally?
Answer Posted / 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 |
Post New Answer View All Answers
How do you remove duplicate records in informatica? And how many ways are there to do it?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is powercenter on grid?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Performance tuning( what you did in performance tuning)
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is xml source qualifier transformation in informatica?
What does “tail –f” command do and what is its use as an Informatica admin.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is the commit type if you have a transaction control transformation in the mapping?
What does role playing dimension mean?
Write the program through which the records can be updated?
How will the document be delivered to me?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance