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 are the types of nodes
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
how many types of sorting the data in data stage?
How to RD using transformer?
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
Display all files which have size more 3KB in given directory/folder.
plz tell me some dimentional and fact table names in banking project?
how can i abort the job if i get more than 100 errors in job log?
what is executable in DataStage?