Answer / jaimy chacko

Use Modify Stage and Drop the columns that are not needed . Or Use a Transformer and take the links tat are only needed(make sure that RCP is not marked )

Answer / kalyanreddy

Hi,

1. based in reuirement if you need 20 columns, you have to
select 20 columns in database query.

2. if source is file, use transformer stage and populate
require 20 columns only

3. if source is database or file you can use copy stage
insted of transformer and modify.

Answer / ram

In the transform stage u select wich coloums u want those
coloums only drage from input link to output link.

Answer / balaji

Using transformation stage
How t o use:
Double click transformation stage

Select 20 columns

Drag and drop there target links.

Click on Ok

Answer / madhu tallapaneni

Use COPY , MODIFY, Transformer
Coming to performance point of use Modify or Copy stage instead of transformer stage while dealing with huge volume of data.

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 is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers  

What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?

1 Answers  

how to find out number of records imported into source file?

1 Answers  

how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

0 Answers   CTS,

can we see the data in fixed width file? how can u change the datatype of fixed width files?

1 Answers   Infosys,

How many number of reject links merge stage can have?

7 Answers   TCS,

souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 Answers  

I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers   TCS,

Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,