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
   Refer this Site  Refer This Site to Your Friends  Site Map  Contact Us      
   
 
 Categories >> Software >> Data Warehouse >> Data Stage
 
Suggest New Category 
 


 

Question Asked @ Answers Views     Select
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on    0  8
Explain the scenarios where sequential file stage runs in parallel?    0  9
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise    0  11
how to call sequential generator in datastage?    0  8
My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this. wipro   2  36
Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del hcl   1  34
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know    1  70
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  463
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  217
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  1079
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  931
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys    0  158
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  608
what is set mapping in datastage?? adp   1  199
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?    1  499
E-Mail New Answers        Answer Selected Questions        Post New data-stage Questions
 [1]    2  ... 4   ... 7   ... 10   ... 13   ... 16   ... 19   ... 22   ... 25   ... 28   ... 31   ... 34   ... 37   ... 40    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views   Select
 
How to display errors in datastage? 167
how do u catch bad rows from OCI stage? And what CLI stands for? 353
which r the connectors used in san? 338
explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT 2188
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. 234
how can we create rank using datastage?what is the meaning of rank? 930
Demonstrate experience in maintaining quality process standards? 229
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also 368
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ? 272
source contains 2 columns comes to target 4 columns how 233
describe the Steps to confiure a Qlogic switch 460
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source? 202
How do you design PX Routines ? 110
how to call sequential generator in datastage? 8
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu 304
E-Mail New Answers        Answer Selected Questions