you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.

3 Answers  

---

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1 Answers  

---

can cubes contain measures ?

0 Answers  

---

What is granularity? Please explain with example

1 Answers   IBM,

---

What is full load & incremental or refresh load?

0 Answers  

---

what are the concerns of OLTP and DSS systems?

0 Answers   TCS,

---

What is the main difference between peek stage and copy stage

2 Answers  

---

How many steps etl contains explain with example?

0 Answers  

---

what is Forward,Reverse and Re_engineering?

0 Answers   QualTech,

---

Eliminating of duplicate records without using dynamic lookups

1 Answers  

---

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?

0 Answers  

---

what do u do when DB time takes more?in sap bi

0 Answers  

---