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?
How to call shell scripts from informatica?
What is meant by LDAP users?
How can you increase the performance in joiner transformation?
What are pre and post-session shell commands?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Is there any target staging area in informatica not staging area
What are the different clients of powercenter?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain the etl program with few examples.
What is the function of look up transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Explain where to store informatica rejected data? How to extract the informatica rejected data?