Answer / arun

Star schema has less joins within its related dimensions so query retreival is faster than SNow-flake.

Space consumed is more than snow-flake

Answer / jz

1) Query performance is high.
2) It consume less space compare to SnowFlake.

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

1 Answers   iGate,

---

What is rank transformation in informatica

0 Answers   Informatica,

---

1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,

---

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,

---

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  

---

How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,

---

What are the tasks that can be performed using sq?

0 Answers  

---

Reusable transformation and shortcut differences

0 Answers  

---

What are the different lookup cache(s)?

0 Answers  

---

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

---

All active transformations r passive or not?

7 Answers  

---

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,

---