Interested to Buy Any Domain ? << Click Here >> for more details...
what is the meant by Normalization and de-normalization?
- 2 Answers
- 8716 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinivas
Normalization:
Normalization is a technique to reduce redundant, and
inconscistent data. normally normalization techniques use
in snoflake schema.
De-normalization:
it is a technique to move high to low normal forms in
datamodeling to increase the performance of databases.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is initial load and what is full load?
how would u estimate the size of Aggregator transform data and index cache?
how do u implement configuration management in Informatica?
What are the different Lookup methods used in Informatica?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
what is pmrep command?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
What is the difference between round-robin partitioning and hash partitioning?
What is staging area referring to?
how to load the data to fact table?
list and discuss two approaches for updation of target table in Informatica and how they are different.
What do you understand by the term ‘transformation’?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
what is pmrep command?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
