Answer / tgin

SELECT BOOKID,DECODE(LANGUAGE,'ENGLISH') AS LANGUAGE1,
DECODE(LANGUAGE,'FRENCH') AS LANGUAGE2,
(LANGUAGE,'SPANISH') AS LANGUAGE3
FROM TABLE_NAME
GROUP BY BOOKID

Why you use repository connectivity?

3 Answers   Yash Technologies,

---

What is parameter file?

2 Answers  

---

How you can differentiate between connected lookup and unconnected lookup?

0 Answers  

---

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  

---

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,

---

---

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null 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

5 Answers   IBM,

---

Can you generate sequence numbers without using the sequence generator transformation?

0 Answers  

---

Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,

---

which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,

---

How you count the number of records available at your source?

3 Answers   Zensar,

---

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

---

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

---