at source level i have 40 columns,i want only 20 cols at target what r the vari

Categories >> Software >> Data Warehouse >> Data Stage
Suggest New Category

at source level i have 40 columns,i want only 20 cols at
target what r the various ways to get it

Question Posted / oct10

5 Answers
11478 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it..

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 )

Is This Answer Correct ?

15 Yes

0 No

at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it..

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.

Is This Answer Correct ?

7 Yes

1 No

at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it..

Answer / ram

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

Is This Answer Correct ?

5 Yes

1 No

at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it..

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

Is This Answer Correct ?

1 Yes

0 No

at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it..

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.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer