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
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
how to write server Routine coding?
Can you explain kafka connector?
On which Dimension Table you implemented SCD Type in your Project
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Difference between server jobs & parallel jobs?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How rejected rows are managed in datastage?
What is a ds designer?
What are the processing stages?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Describe the architecture of datastage?
What is quality stage?