at source level i have 40 columns,i want only 20 cols at
target what r the various ways to get it
Answer Posted / jaimy chacko
Use Modify Stage and Drop the columns that are not needed . Or Use a Transformer and take the links tat are only needed(make sure that RCP is not marked )
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
How can you write parallel routines in datastage PX?
How to reverse the string using SQL?
What is a quality stage in datastage tool?
What is the difference between odbc and drs stage?
Difference between sequential file and data set?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How to Remove Duplicate using SQL?
what is the use of materialized view?
Differentiate between datastage and informatica?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What is the difference between operational data stage (ods) and data warehouse?
Can you explain players in datastage?
Define ds designer?
Difference between ‘validated ok’ and ‘compiled’ in data stage?