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


Please Help Members By Posting Answers For Below Questions

why do u need the IOS upgradation in a FC switch

1860


Why do we use link partitioner and link collector in datastage?

676


What is the difference between account and directory options ?

614


Can we use target hash file as a lookup ?

2806


Which algorithm you used for your hashfile?

681






What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2531


What is the difference between passive stage and active stage?

809


how to abort the job its matain duplicates?

2091


Where do the datastage jobs get stored?

715


Explain the datastage parallel extender (px) or enterprise edition (ee)?

719


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2835


How to reverse the string using SQL?

881


I have a few records just I want to store data in to targets cycling way how?

1887


Have you have ever worked in unix environment and why it is useful in datastage?

639


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2416