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 Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,

---

how to find no.of records in sequntial file itself?

4 Answers  

---

In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.

1 Answers   IBM,

---

What is Fastly Changing Dimension?

6 Answers   TCS,

---

If the job aborted in a sequencer, how can we start that from the previews successful job.

1 Answers   SLK Software,

---

What is the function in Transformer stage can act as Rank Function in oracle

1 Answers   Reliance,

---

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,

---

what is the use of surogate key in datastage

0 Answers   TCS,

---

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

4 Answers   ME,

---

How can you write parallel routines in datastage PX?

0 Answers  

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

0 Answers   JPMorgan Chase,

---