insequential file 2header avaliable,and 100 records
avaliable.how to skip the 2 headers and load 100 records
target?
Answers were Sorted based on User's Feedback
Answer / manu
By using 'SED'command like this
for header sed -n '1|p’
| Is This Answer Correct ? | 3 Yes | 0 No |
Explain the functionality of your current project?
1 Answers IBM, Miles Software,
Define orabulk and bcp stages?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Why we use surrogate key?
what is factless fact table?
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 are the components of ascential data stage?
What are the primary usages of datastage tool?
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
How do you load dimension data and fact data? Which is first
How to add zero "0" before record in a field?
What is a merge?