Answer Posted / srini

Can anyone pls cc me as well
srini.rao99@yahoo.com

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?

1866

---

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?

2896

---

can be used COM component in Informatica ?

2065

---

what is Forward,Reverse and Re_engineering?

2203

---

what is the difference between cardinality and Nullability?

3458

---

how do u set partition points in the mapping?

2245

---

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?

2041

---

Is hadoop a etl tool?

955

---

how to load the data to fact table?

2710

---

Explain do we need an etl tool?

1027

---

Can we create Hierarchies in generic datasources?

2387

---

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.?

950

---

What are the different etl testing categories as per their function?

1082

---

What are your responsibilities as an etl tester?

1166

---

Compare etl & elt?

1017

---