Answer Posted / rekha
DATA MERGING : IT IS THE PROCESS OF INTEGRATING THE SOURCES
WITH SIMILAR STRUCTURE AND SIMILAR TYPE
TABLE A
ENO ENAME
100 REKHA VARCHAR2(10)
TABLE B
ENO ENAME
101 SAHAN VARCHAR
SO U CAN MERGE TO COMMAON DATATYPE STRING IN THE ABOVE CASE
dATA CLEANSING :
IT IS THE PROCESS OF IDENTIFING THE INCONSISTANCIES AND
INACCURACIES
DATASAMPLING:
ARBITARILY CHOOSING THE RECORDS FROM GROUP OF RECORDS FOR
TEST
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is different between the data warehouse and data mart?
What is the surrogate key?
Mention few advantages of router transformation over filter transformation.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is a filter transformation and why it is an active one?
Explain what transformation and how many are there in informatica?
What does command task mean?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How you prepared reports for OLAP?
Explain the aggregator transformation?
What are the new features of Power Center 5.0?
What are active and passive transformations?
Differences between connected and unconnected lookup?
What is the status code in stored procedure transformation?
What is flashback table ? Advance thanks
