how do u reduce warnings
In order to reduce the warnings you need to get clear idea
about particular warning, if you get any idea on code or
design side you fix it, other wise goto director-->select warning and right click and add rule to message, then click
ok. from next run onward you shouldn't find any warnings.
| Is This Answer Correct ? | 9 Yes | 2 No |
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
Explain the importance of surrogate key in data warehousing?
How we can convert rows to columns in datastage?
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
specify data stage strength?
What are sequencers?
What is job control?
In which situations we can use normal and sparse lookup stages
Can we use target hash file as a lookup ?
why dataset ?
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?
What is the difference b/w Hash file and Lookup Fileset stages?