at source level i have 40 columns,i want only 20 cols at
target what r the various ways to get it
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
what r the sources u need to create the datastage?
why we use hash file for lookup?
sed,awk,head
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
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
What are the types of containers?
Can aggregator and transformer stages use to sort the data? How ?
How many types of views are there in a datastage director?
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
what is the exact difference between dataset and fileset in datastage?
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?