:: 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
   Testimonials 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
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.    1  238
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.    1  110
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)    0  94
how to load meta data    0  87
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer    0  60
A signal has a wavelength of 1 micro min in far can the front of the wave travel during 1000periods?    0  105
client know skid info?    0  196
what is the use of skid in reporting?    0  157
Is possible to create skid in dim,fact tables?    0  135
whom do you report?    0  140
How will you move hashed file from one location to another location?    0  208
In one project how many shared containers are created?    1  393
which unix commands mostly used in datastage    1  564
which dim, fact tables used in bank domain    1  387
what is materialized view used datastage?    1  364
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   ... 43    Next
Un-Answered Questions
 Question Views   Select
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS? 581
what is flow of project? 119
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. 928
How can we select pr retrieve the particular row in dataset by using orchadmin command? 1303
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals 388
Demonstrate experience in maintaining quality process standards? 585
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 550
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction? 480
How do you get log info into a file? 381
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format? 682
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records 228
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do? 556
How to convert RGB Value to Hexadecimal values in datastage? 1570
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ? 694
E-Mail New Answers        Answer Selected Questions