:: 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                      
 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  0  9
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  399
Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be to do this?? IBM  1  161
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  1001
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  869
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys  0  138
My input has a unique column-id with the values 10,20, 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  547
what is set mapping in datastage?? ADP  0  148
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?  1  442
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  981
What is difference between 8.1 , 8.5 and 9.1 ? IBM  0  523
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage. CTS  0  200
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  1008
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  177
how does work server jobs?  1  277
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 to use self join using datastage ? can u tell me using stage how can we implemnet the self join 674  
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ? 263 ABC
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes. 616  
what are the different type of errors in datastage? 1091 Wipro
On which Dimension Table you implemented SCD Type in your Project 224  
Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container? 116 TCS
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do? 244 TCS
How to lode data in sequntional files perform faster? 213 Polaris
What is the function in Transformer stage can act as Rank Function in oracle 317 Reliance
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema? 188 TCS
E-Mail New Answers        Answer Selected Questions

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