Interested to Buy Any Domain ? << Click Here >> for more details...
list the transformation used for the following:Heterogeneous
sources,Homogeneous sources,Find the 5 highest paid
employees with in a dept,create a summery table,generate
surrogate keys
- 2 Answers
- 7196 Views
- I also Faced
- E-Mail Answers
Answer Posted / dw_worker
Heterogeneous sources - Joiner
Homogeneous sources - Source Qualifier
Find the 5 highest paid employees with in a dept - Rank
Create a summary table - Aggregator
Generate surrogate keys - Sequence Generator
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are three tier systems in etl?
what is session partitioning?
What is a staging area? What is the purpose of a staging area?
what are the data modeling tools you have used?(polaris)
Compare etl & elt?
What is a lookup table in etl?
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.
what do u do when DB time takes more?in sap bi
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
SCD2 will work on only dimension tables as well as fact Table?
What is etl process. How many steps etl contains explain with example?
What are dimensions?
what happens if the info.server doesn't find the session parameter in the parameter file?
Two default user groups created in the repository are____and_____.
Do we need an etl tool?
