1)How to Duplicate Records Delete in Sequential file?
Answer Posted / naga
connect sequential file to dataset and use partition
technique and perform sort and select unique
| Is This Answer Correct ? | 19 Yes | 6 No |
Post New Answer View All Answers
How to read multiple files using a single datastage job if files have the same metadata?
What are the different options associated with dsjob command?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is the use of datastage designer?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the process of killing a job in datastage?
What are orabulk and bcp stages?
project Steps,hits, Project level HArd things,Solved methods?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Name the different sorting methods in datastage.
Explain the importance of surrogate key in data warehousing?
how to implement scd2 in datastage 7.5 with lookup stage
What is the difference between odbc and drs stage?
Differentiate between datastage and datastage tx?