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
- 11225 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the benefits of datastage?
What are transforms and what is the differenece between routines and transforms?
Which commands are used to import and export the datastage jobs?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
How to read multiple files using a single datastage job if files have the same metadata?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is ds designer?
How we can covert server job to a parallel job?
What are the types of containers?
How do you remove duplicate values in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How can we improve the performance in datastage?
Can you explain link buffering?
Explain the importance of surrogate key in data warehousing?
What is meta stage?
