Interested to Buy Any Domain ? << Click Here >> for more details...
at source level i have 40 columns,i want only 20 cols at
target what r the various ways to get it
- 5 Answers
- 11234 Views
- IBM, I also Faced
- E-Mail Answers
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 features of datastage flow designer?
How the ipc stage work?
How can we do null handling in sequential files?
HOW CAN WE SEE THE DATA IN DATASET?
What is the difference between an operational datastage and a data warehouse?
Differentiate between validated and Compiled in the Datastage?
how CAN we remove duplicates in dataset?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
what is the definitions for Datawarehose and Datamart?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
WHAT IS FORCE COMPILE?
Teradata 
