at source level i have 40 columns,i want only 20 cols at
target what r the various ways to get it
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 size of a transaction and an array means in a datastage?
How the ipc stage work?
Explain connectivity between datastage with datasources?
What is staging variable?
what is the use of materialized view?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How to perform incremental load in datastage?
In Datastage, how you can fix the truncated data error?
To see hidden files in LINIX?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Different ways a project can be moved to production ?...example ….export-import and Version control.
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join