what are the facilities provided by OLAP to analytical users?
Answer / maruthi
1.)MULTI-DIMENSIONAL ANALYSIS
2>)AD-HOC QURIES
3.)REDUCED REDUNDANCY
4.)AGGREGATED DATA
5.)SECURITY
| Is This Answer Correct ? | 1 Yes | 0 No |
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.
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
How to Check the source record count from traget table.
what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.
Explain about hash partitioning?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Two default user groups created in the repository are____and_____.
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
Can u access a repository created in previous version of Informatica?
When do we analyze the tables? How do we do it?
what is the difference between cardinality and Nullability?