Answer Posted / shashiall
DWH is DSS(Dicision support system),whereas, OLTP is not
DSS.
| Is This Answer Correct ? | 2 Yes | 10 No |
Post New Answer View All Answers
What is a transaction control transformation?
What is option by which we can run all the sessions in a batch simultaneously?
Explain sessions. Explain how batches are used to combine executions?
What is an active transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Explain dynamic target flat file name generation in informatica
whats the logic to load the lower level of granularity of data to fact table.
How do you load alternate records into different tables through mapping flow?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Is it possible to revert a global repository to local one and why?
What are the mapping parameters and mapping variables?
What are pre and post-session shell commands?
Can you generate sequence numbers without using the sequence generator transformation?