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?????  2  336
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  0  98
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  942
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  812
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys  0  113
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  496
what is set mapping in datastage?? ADP  0  121
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?  1  399
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  929
What is difference between 8.1 , 8.5 and 9.1 ? IBM  0  466
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage. CTS  0  179
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  959
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  160
how does work server jobs?  1  240
what is diff b/w datastage 8.1,8.5,8.7? ibm  1  528
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
 
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase? 175  
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable) 257 IBM
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. 600  
How to convert RGB Value to Hexadecimal values in datastage? 445  
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? 942 Cognizent
Explain the situation where you have applied SCD in your project? 93  
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance? 239  
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks. 115  
how to implement scd2 in datastage 7.5 with lookup stage 853 TCS
How to lode data in sequntional files perform faster? 210 Polaris
I am getting input value like X = Iconv(31 DEC 1967,D)? What is the X value? How it is? At what situation we r used Iconv(),Oconv(). 207 AMDOC
explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT 2124 IBM
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