Answer / james

Semi-additive facts are the measures in which they can be
added in some dimensions and cannot be added in some
dimensional tables.They are used in fact table loading.

Answer / ramana

The fact value decided by some of the dimensions values,then that fact is called semi additive fact.

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  

---

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,

---

What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,

---

Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,

---

What are the types of presistent cache in look up tr.

0 Answers   IBM,

---

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  

---

What is different between the data warehouse and data mart?

0 Answers  

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

---

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,

---

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

---

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

---