how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,

---

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

---

what type of problem you faced insales project or insurance project

1 Answers   Sony,

---

what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,

---

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  

---

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  

---

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

---

HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers   TCS,

---

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

---

What is log file,and where is it located,why u r using the log file

1 Answers   TCS,

---