Answer Posted / akash

There are 2 questions:
1. To load session statistics:
For this we can use 2 concurrent sessions.

Session 1 --> Session 2

The condition for session 2 will be 'Session 1 Status =
Succeeded'.

The source file in the mapping corresponding to session 2
will be the log file of session 1 and output file will have
the desired results.

Question2: How to pass values from oracle table into
mapping parameters or variables?
Frankly speaking, I have no idea of doing this as I have
passed values from the parameter file.
But in case we need the values from oracle table only then
we can create a variable port in an expression and do a
look up on the oracle table.

Since we need this value only once we can use a condition
in expression for using look up only once.

Another alternative is to take the value for this port
right from the source qualifier as an additional port.

what are the concerns of OLTP and DSS systems?

1897

---

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

1013

---

What is partitioning? Explain about round-robin, hash partitioning.

894

---

hoe to access second value in mapping parameter if it is having more than one value ?????????????

1479

---

How many steps etl contains?

876

---

Explain about round-robi?

1076

---

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

2306

---

What is staging area referring to?

1048

---

What are the steps involved in etl process?

949

---

What is a staging area? What is the purpose of a staging area?

824

---

What are the ETL Testing Operations?

987

---

What is tracing level and what are the types?

889

---

How to increase performance without changing anything in mapping.( In prod)

1200

---

what are the concerns of OLTP and DSS systems?

2394

---

What is abap? What are idocs?

915

---