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 is session partitioning?

2197

---

Explain do we need an etl tool?

1071

---

How can we use external procedural logic in informatica?

957

---

Explain etl mapping sheets?

1123

---

What is data cleaning?

993

---

Define slowly changing dimensions (SCD)?

1095

---

What are dimensions?

1116

---

Explain about round-robi?

1198

---

what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

2164

---

What are snapshots?

1027

---

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

2224

---

what is dynamic insert?

2249

---

When do we analyze the tables? How do we do it?

996

---

Explain and compare etl & manual development?

968

---

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2527

---