tell me the datawarehouse defination,and it is maintaing
hystorical data meaning,what is the use
Answer / abhinaw prakash
Data warehouse is the coordinated,periodic copying of data
from different sources both inside and outside the
enterprise into an environment optimized for analytical and
informational processing.
By Historical data means that historical data will also be
kept along with the most recent data unlike the OLTP system.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the different types of repositories created using informatica?
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
differences between service based and product based?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
wf dont have integration severances how you can run?
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
expain about the tune parameters?
Define Pmrep command?