Compare etl & elt?
No Answer is Posted For this Question
Be the First to Post Answer
without using ETL tool can u prepare a Data warehousing and maintaining?
what is pmrep command?
what is the difference between shortcut of an object and copy of an object? compare them?
What do you understand by active and passive transformations?
what is dynamic insert?
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
Two default user groups created in the repository are____and_____.
What is partitioning? Explain different types of partitioning?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
What are the various tools used in etl?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record