ALLInterview.com :: Home Page            
 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                      
Google
   
 
 Categories >> Software >> Data Warehouse >> Data Stage       
Suggest New Category 
 


 

View Page with Answers
  Question  Asked @ Answers Views     select
 
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage? Cognizent  1  147
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks Cap-Gemini  2  241
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys  0  57
My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?  1  175
what is set mapping in datastage?? ADP  0  55
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?  1  129
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records? Caterpillar  3  576
What is difference between 8.1 , 8.5 and 9.1 ? IBM  0  148
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage. CTS  0  130
Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks. UHG  3  630
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.  0  116
how does work server jobs?  1  115
what is diff b/w datastage 8.1,8.5,8.7? ibm  1  199
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ? ABC  0  161
whats relation between configuration file and datasets? L&T   1  433
E-Mail New Answers        Answer Selected Questions        Post New Data Stage Question
 [1]    2  ... 4   ... 7   ... 10   ... 13   ... 16   ... 19   ... 22   ... 25   ... 28   ... 31   ... 34   ... 37    Next
 
 
    Teradata Interview Questions     Business Objects Interview Questions     Cognos Interview Questions
    Informatica Interview Questions     Crystal Enterprise Suite Interview Questions     Actuate Interview Questions
    Ab Initio Interview Questions     Data Stage Interview Questions     SAS Interview Questions
    Micro Strategy Interview Questions     ETL Interview Questions     Data Warehouse General Interview Questions
 
 
 
Un-Answered Questions
 
 Question Views Asked at   Select
 
why do we need a datawarehouse when we have databases to store data? 72 L&T
What is the purpose of interprocessor stage in server jobs? 114  
how to find diff between 2 dates without using Icon... funtions? 178  
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys 57  
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES? 1611 HCL
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks. 102 IBM
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction? 175 Reliance
Explain the situation where you have applied SCD in your project? 83  
Is it possible to query a hash file? 157 IBM
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? 316 Wipro
what is set mapping in datastage?? 55 ADP
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. 199 JPMorgan-Chase
E-Mail New Answers        Answer Selected Questions
 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com