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
   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
Thanks to all people who are posting their comments...    1  11
DataStage Scenario based Interview Questions    1  77
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers    4  753
Unix command to view the data in a dataset    2  824
How to move data set from one server to other?what are the steps to follow to do this?    1  363
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.    2  1208
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.    4  1799
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.    2  1028
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)    1  1348
how to load meta data    2  357
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer    1  311
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?    0  325
client know skid info?    0  409
what is the use of skid in reporting?    0  489
Is possible to create skid in dim,fact tables?    0  359
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
 
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? 541
Can we use target hash file as a lookup ? 738
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company. 555
what is the custome stage in datastage? how can we impliment that one? plz tell me 716
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same? 633
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10) 1284
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also 1623
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ? 559
How to find value from a column in a dataset? 645
what is the use of skid in reporting? 489
how many rows sorted in sort stage by default in server jobs 1961
Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage. 4347
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance... 2467
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination 611
What is process model? 392
E-Mail New Answers        Answer Selected Questions