ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Data Stage
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
at source level i have 40 columns,i want only 20 cols at
target what r the various ways to get it
 Question Submitted By :: Oct10
I also faced this Question!!     Rank Answer Posted By  
 
  Re: at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it
Answer
# 1
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 ?    3 Yes 0 No
Jaimy Chacko
 
  Re: at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it
Answer
# 2
In the transform stage u select wich coloums u want those
coloums only drage from input link to output link.
 
Is This Answer Correct ?    0 Yes 0 No
Ram
 
 
 

 
 
 
Other Data Stage Interview Questions
 
  Question Asked @ Answers
 
WHAT ARE THE COMMON ERRORS IN DATA STAGE? ME5
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table? TCS1
what is sparse lookup?  5
Wat is isolation level and when do u use them? HP1
HOW CAN U DO ERROR HANDLING IN DATA STAGE? ME5
what is combinability and non combinability?  1
Explain the ChangeApply stage?  2
WHAT are unix quentios in datastage TCS1
Tell me Wt main advantage of Stage varibles? Project level hints? Hexaware3
what is main difference between change capture and change apply stages IBM3
Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me? Scope-International2
how can we extract data with out having any common column IBM5
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?  3
What are the different database update actions available? HP1
How do y read Sequential file from job control? HP1
What modeling tool do you use? HP5
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version? Wipro7
what is datastage job Monitoring CTS2
How can we run same job in 1 day 2 times IBM3
what is meta data? Explain? Where it is used?  7
 
For more Data Stage Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com