Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / srinivas
hi friends,
this is right friends , bt oltp is current data. olap
maintains historical data for analyzing purpose.. olap is
read-only data. it is denormized data . it has dimession
table ,fact table data .
it has detailed data
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Write the advantages of partitioning a session?
draw informatica architecture 8.6 ?
How are the sources and targets definitions imported in informatica designer?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
can you please explain me pre session and post session options?
What is dynamic cache?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What does refresh system mean, and what are its distinctive choice?
What are the features of complex mapping?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the Rank index port in Rank transformation?
my source is junk data how will u remove that junk data by using unix please any one replay me
Differentiate between joiner and lookup transformation?
What is DR strategy for Informatica project?
