Answer / srinu

when the memory limit requirement is more then we go for
dataset.because sequential file does not support more than
2gb memory limit

source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers   IBM,

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

0 Answers   Wipro,

---

What is a quality stage in datastage tool?

0 Answers  

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

0 Answers  

---

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq

9 Answers   Patni,

---

I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?

1 Answers   TCS,

---

what is the difference between the join and look up explin me one exmple

3 Answers  

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

0 Answers  

---

how can we send even and odd records from a sequential file to two different targets

10 Answers   IBM, iGate, TCS,

---

What are stage variables and constants?

0 Answers  

---

Explain the situation where you have applied SCD in your project?

0 Answers  

---

Explain the importance of surrogate key in data warehousing?

0 Answers  

---