Answer / shiva

To store the data in a particular dimension

Useful UNIX commands regular/frequently used

1 Answers   Deloitte,

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers  

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

0 Answers  

---

Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  

---

what is lookupoverriding?

1 Answers  

---

What is junk dimention?

3 Answers   Patni,

---

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow

4 Answers   Wipro,

---

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  

---

How does the server recognize the source and target databases. Elaborate on this.

1 Answers  

---

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

---

What is a stored procedure transformation?

0 Answers  

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---