Answer / pandu

For testing the jobs developer required sample data so we will get the sample data with row generator stage

Answer / dhana

The Row Generator stage is a Development/Debug stage. It has no input links, and a single output link.

The Row Generator stage produces a set of mock data fitting the specified meta data. This is useful where you want to test your job but have no real data available to process.

By default it generates values for the metadata we specified and we can also specify the data to be generated for the metadata we are using.

Explain connectivity between datastage with datasources?

0 Answers  

---

What is the use of datastage designer?

0 Answers  

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers  

---

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

5 Answers   IBM,

---

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,

---

Terminate Activity

0 Answers   CTS,

---

what is set mapping in datastage??

2 Answers   ADP,

---

What is difference between symmetric multiprocessing and massive parallel processing?

0 Answers  

---

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  

---

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,

---

What are the repository tables in datastage?

0 Answers  

---

Name the command line functions to import and export the DS jobs?

0 Answers  

---