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
DataStage Scenario based Interview Questions    1  7
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    2  534
Unix command to view the data in a dataset    2  584
How to move data set from one server to other?what are the steps to follow to do this?    1  260
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.    2  987
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.    3  1596
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  888
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  1144
how to load meta data    2  278
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  246
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?    0  299
client know skid info?    0  381
what is the use of skid in reporting?    0  457
Is possible to create skid in dim,fact tables?    0  332
whom do you report?    0  304
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
 
Can we use target hash file as a lookup ? 718
How do you get log info into a file? 443
what are the errors,warnings in datastage 934
what is the custome stage in datastage? how can we impliment that one? plz tell me 698
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ? 1873
What are the partitioning techniques available in link partitioner? 427
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 ? 556
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) 710
what is the use of skid in reporting? 457
How to lode data in sequntional files perform faster? 736
Explain the situation where you have applied SCD in your project? 290
What is process model? 388
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 1072
Is it possible to query a hash file? 541
how to create document in datastage? 1502
E-Mail New Answers        Answer Selected Questions