Answers were Sorted based on User's Feedback
Answer / rekha
DATA MERGING : IT IS THE PROCESS OF INTEGRATING THE SOURCES
WITH SIMILAR STRUCTURE AND SIMILAR TYPE
100 REKHA VARCHAR2(10)
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
ARBITARILY CHOOSING THE RECORDS FROM GROUP OF RECORDS FOR
|Is This Answer Correct ?||2 Yes||0 No|
Data Merging: It is a process of combning Non-Similar
structures or Similar structure data into Target Warehouse
To combine Non Similar we can use Joins Concept,For
Similar We can use Union Concept
Data Cleansing:It is a process of converting Non Unique
data format of the source system into unique data format of
Target Warehouse system.
I dont Know definion for Data Sampling..can anyone plz give
|Is This Answer Correct ?||2 Yes||1 No|
Answer / rakesh
Is the process of merging non similar structure data (or)similar structure data into target warehouse system;
IS the process of converting source Non-Unique data format into unique data format into target warehouse system.
it is the process ,orbitarly reading the data from
group of records.
|Is This Answer Correct ?||0 Yes||0 No|
Answer / dr.jornalist
Datamerging: This is the process of
Datacleansing:- Removing the Data inconsistencies and
Data sampling:- Arbitorily taking the data from the group
of records for the sample purpose.
|Is This Answer Correct ?||2 Yes||4 No|
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
What is the use of incremental aggregation?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
have you developed documents in your project? and what documents we develop in realtime?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
How would you copy the content of one repository to another repository?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Describe an informatica powercenter?
Can we create two repositories on same database instance in oracle?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
What is Java Transformation? what are the uses of it?