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 
 


 

  Question  Asked @ Answers Views     select
 
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????  3  381
Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this?? IBM  1  142
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  4  983
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  3  852
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys  0  132
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? Wipro  2  534
what is set mapping in datastage?? ADP  0  139
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?  1  431
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  966
What is difference between 8.1 , 8.5 and 9.1 ? IBM  0  507
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage. CTS  0  196
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  4  994
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  173
how does work server jobs?  1  268
what is diff b/w datastage 8.1,8.5,8.7? ibm  1  565
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
 
 
 
 
 
Un-Answered Questions
 
 Question Views Asked at   Select
 
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this? 128 Wipro
how can we create rank using datastage?what is the meaning of rank? 883 IBM
Display all files which have size more 3KB in given directory/folder. 156 TCS
how to add a new records into source? 149  
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10) 466 Polaris
How do you get log info into a file? 147  
how to implement scd2 in datastage 7.5 with lookup stage 875 TCS
why do we need a datawarehouse when we have databases to store data? 97 L&T
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ? 267 IBM
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase? 178  
Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me 177  
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction? 190 Infosys
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