pls ,tell me good Training centre with Job Oppertunity for
Data stage in chennai?
Mohammadsadiq Tapal
Bangalore
Contact no: 09449761890
Mail Id : sadique.tapal@gmail.com
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between hashfile and sequential file?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?
count number of deptno in a emp table?
What is the difference b/w Hash file and Lookup Fileset stages?
how to find out number of records imported into source file?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
Describe routines in datastage? Enlist various types of routines.
EXPLAIN SCD