Answer Posted / lokesh
first we need to converted flat files in tables ofter join
the oracle and that table
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Explain how a source file is populated?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Define Data Stage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are the functionalities of link collector?
Define ds designer?
how to sort two columns in single job in datastage.
sed,awk,head
Explain the datastage parallel extender (px) or enterprise edition (ee)?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
project Steps,hits, Project level HArd things,Solved methods?
What are the different types of lookups in datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are the stages in datastage?