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
 
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know  1  32
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?????  4  420
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  180
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  7  1022
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  888
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys  0  144
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  569
what is set mapping in datastage?? ADP  1  165
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?  1  463
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  1001
What is difference between 8.1 , 8.5 and 9.1 ? IBM  0  546
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage. CTS  0  209
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  1025
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  182
how does work server jobs?  1  290
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
 
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) 470 Polaris
How do you get log info into a file? 147  
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also 364  
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. 182  
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE 811  
what is hash file 215 CTS
how can we create rank using datastage?what is the meaning of rank? 904 IBM
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ? 269 IBM
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do 220 IBM
Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises 441 TCS
in oracle target stage when we use load option and when we use upsert option? 166  
How to convert RGB Value to Hexadecimal values in datastage? 459  
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