Answer Posted / shekhar

Please CC to my email Id shekhar.singh010@gmail.com

Thanks in advance :)

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

1482

---

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2839

---

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

1135

---

what are the facilities provided by data warehouse to analytical users?

2009

---

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

888

---

What are the key benefits of ETL Testing?

986

---

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

1821

---

Explain the key challenges that you face while performing etl testing.

949

---

What do you understand by active and passive transformations?

882

---

When do we analyze the tables?

900

---

Compare etl & elt?

948

---

what is the main role of FI on business

2035

---

What are the various tools used in etl?

971

---

how to load the data to fact table?

2638

---

Compare ETL & Manual development?

897

---