Interested to Buy Any Domain ? << Click Here >> for more details...
without using ETL tool can u prepare a Data warehousing and
maintaining?
- 3 Answers
- 8158 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bharathikmylearningsphere
Yes , it is possible to create a datawarehouse without
using ETL tool. but it will be very very complicated and
time consuming and if the needs change you need to re-work
on it again.but when you use etl tools you can adapt you
can make the changes as required.
| Is This Answer Correct ? | 7 Yes | 4 No |
Answer / zak
Theoritically speaking Yes. Preparing a Datawarehouse and
maintaining will only be feasible when the amount of Data
you are dealing with is small. Practically Datawarehouses
will have huge data with large number of tables and complex
business rules which may keep changing from time to time.
All this makes practically impossible to implement DWH just
by writing database queries.
| Is This Answer Correct ? | 1 Yes | 0 No |
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
what is session partitioning?
what are the reports developed in sap bw project and what is the requirement for developing it?
WHY CANT WE SEE THE DATA IN DATASET
Explain what is etl process? How many steps etl contains explain with example?
When do we go for the tools in the market?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
What is granularity? Please explain with example
How many steps etl contains explain with example?
Compare etl & elt?
how do u identify the changed records in operational data?
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.
Teradata 
