Difference in the implementation of lookup and join stages,in joining two tables?

7 Answers   TCS,

---

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers   TCS,

---

How to lode data in sequntional files perform faster?

1 Answers   Polaris,

---

In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario

3 Answers  

---

1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?

7 Answers   Wipro,

---

hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 Answers  

---

Is the value of staging variable stored temporarily or permanently?

0 Answers  

---

Triggers,VIEW,Procedures

0 Answers   CTS,

---

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

5 Answers   TCS,

---

Describe the architecture of datastage?

0 Answers  

---

i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?

5 Answers   TCS,

---

How to enter a log in auditing table whenever a job get finished?

2 Answers   L&T,

---