what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

0 Answers  

---

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,

---

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

0 Answers   IBM,

---

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,

---

How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,

---

---

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,

---

explain different levels in pushdown optimization with example?

2 Answers   TCS,

---

How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 Answers  

---

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,

---

What is the procedure to load the fact table.Give in detail?

1 Answers  

---

Separate from an archive server and a powerhouse?

0 Answers  

---

why we r using presql&postsql in source qualifier?

1 Answers   HP,

---