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
- 11477 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 features of datastage flow designer?
Explain connectivity between datastage with datasources?
Name the third party tools that can be used in datastage?
What are the different layers in the information server architecture?
how to implement scd2 in datastage 7.5 with lookup stage
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the importance of the exception activity in datastage?
Differentiate between odbc and drs stage?
What is the difference between odbc and drs stage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What is the difference between hashfile and sequential file?
what are the errors,warnings in datastage
What is aggtorec restructure operator?
How can we improve the performance in datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
