Answer Posted / prasuna
Data Merging: It is a process of combning Non-Similar
structures or Similar structure data into Target Warehouse
system.
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
the answer...
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is a sequence generator transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Enlist the advantages of informatica.
4 yrs etl devloper roles and responsibilities?any body give solutions
Have you worked with/created Parameter file
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Implementation methodology
What is the need of etl tools?
What is deployment group?
Partition, what happens if the specified key range is shorter and longer
What are the different transaction levels available in transaction control transformation?
How big was your fact table
Slowly changing dimensions, types and where will you use them
How to generate sequence numbers without using the sequence generator transformation?
