Answer Posted / pooja

To read multiple files in a sequential file follow the
below process..

1. Enable "Allow Multiple Instances" in the Job Properties.
2. Add a job parameter in the sequential file stage where
the input file needs to be defined.
3. Compile and execute the job.
4. During execution, a value needs to be passed to the job
parameter..here pass the input file path placed in
different directories.
5. Execute the job for all the multiple files using the
same job by passing the input file path for each run.
6. An invocation id needs to be provided for each run. This
id indicates the no. of times the job has been executed.
Can be observed in the log.

Can you define merge?

1186

---

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

2084

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2288

---

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?

2284

---

root tree will find which is server job and which is parallel job?

2036

---

how to export or import the jobs in .ISX file

1248

---

What is the difference between datastage and datastage tx?

1112

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

852

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2547

---

Difference between server jobs & parallel jobs?

1128

---

Nls stands for what in datastage?

1228

---

Can you implement SCD2 using join, transformer and funnel stage?

1601

---

table actions available in oracle connector?

1649

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2245

---

What can we do with datastage director?

1289

---