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
- 11294 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 is the custome stage in datastage? how can we impliment that one? plz tell me
how to delete one row in target dataset
What is the use of hoursfromtime() function in transformer stage in datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
EXPLAIN SCD
What are data elements?
root tree will find which is server job and which is parallel job?
Distinguish between informatica & datastage. Which one would you choose and why?
What is the difference between Datastage 7.5 and 7.0?
Is the value of staging variable stored temporarily or permanently?
What are the difference types of stages?
What is the difference between orabulk and bcp stages?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Name the third party tools that can be used in datastage?
Define APT_CONFIG in Datastage?
