What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

---

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

---

What is a shortcut and copy in Informatica and how two are different with each other?

0 Answers  

---

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  

---

what is sql override?what is the use of it?

4 Answers   Sonata,

---

How you know when to use a static cache and dynamic cache in lookup transformation?

0 Answers  

---

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

---

whats the option in informatica 7 version is outdated in informatica 8 version onwards.

1 Answers   iGate,

---

What is xml source qualifier transformation in informatica?

0 Answers  

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

---