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  18
Explain the scenarios where sequential file stage runs in parallel?    0  14
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise    0  15
how to call sequential generator in datastage?    0  13
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   3  51
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  46
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know    1  80
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  473
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  227
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  1094
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  943
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys    0  161
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  621
what is set mapping in datastage?? adp   1  209
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?    1  514
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
 
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks. 130
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive. 245
root tree will find which is server job and which is parallel job? 117
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? 135
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction? 199
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance 225
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 18
what are .ctl(control files) files ? how the dataset stage have better performance by this files? 309
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys 161
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do? 252
How can we select pr retrieve the particular row in dataset by using orchadmin command? 373
Explain the situation where you have applied SCD in your project? 97
how to add a new records into source? 154
create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt &#8722; min_lvl between 0 and 25 inclusive. &#8722; Same column types and headings as Jobs.txt. &#8722; Include column names in the first line of the output file. &#8722; Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt &#8722; min_lvl between 26 and 100 inclusive. &#8722; Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt &#8722; min_lvl between 101 and 500 inclusive. &#8722; Same format and derivations as Target file 1. • Rejects file: JobRejects.txt &#8722; min_lvl is out of range, i.e., below 0 or above 500. &#8722; This file has only two columns: job_id and reject_desc. &#8722; reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: <min_lvl>”, where <min_lvl> is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows. 463
On which Dimension Table you implemented SCD Type in your Project 230
E-Mail New Answers        Answer Selected Questions