 Related Questions Fact table - Table with Collection of Foreign Keys corresponding to the Primary Keys in Dimensional table. Consists of fields with numeric values. Dimension table - Table with Unique Primary Key. Load Latest Answer : __________________ _______________ ________________|_________________| |______________ ... Primary Key is a combination of unique and not null. It can be a collection of key values called as composite primary key. Partition Key is a just a part of Primary Key. There are several methods of partition Latest Answer : Hi:Primary key is the key we define on the table column or set of columns(composite pk) to make sure all the rows in a table are unique.Partition key is the key that we use while partition the table(in database), process the source records in ETL(in the ... There are 3 types of views in Datastage Director a) Job View - Dates of Jobs Compiled. b) Log View - Status of Job last run c) Status View - Warning Messages, Event Messages, Program Generated Messages. Latest Answer : From what I know there are four views1> Status 2> Schedule3> Log4> Detail. ... A) Transformer, ORAOCI8/9, ODBC, Link-Partitioner, Link-Collector, Hash, ODBC, Aggregator, Sort. 100+ jobs for every 6 months if you are in Development, if you are in testing 40 jobs for every 6 months although it need not be the same number for everybody Latest Answer : Depends on which type of project you are working. Sometimes in Parallel Jobs we will take more time to finish complex job. If you have 3 years experience then you have to tell more than 100 Jobs, Few jobs in server and few in parallel ... Give the OS of the Server and the OS of the Client of your recent most project Latest Answer : server is unix and client machine i.e is ur machine where u design a job is windows xp professional ... Either used Copy command as a Before-job subroutine if the metadata of the 2 files are same or created a job to concatenate the 2 files into one if the metadata is different. Latest Answer : Use the merge plug-in stage which can merge two files based on the defined key fields by using, INNER or OUTER joins, UNION, Intersection or Minus operations. ... Always parameterized the job. Either the values are coming from Job Properties or from a ‘Parameter Manager’ – a third part tool. There is no way you will hard–code some parameters Latest Answer : hi please send me some real time questions in datastage for interview.i have interview on sunday for accenturehow do u implement rank in datastage os: windows ... Have you ever involved in updating the DS versions like DS 5.X, if so tell us some the steps you have taken in doing so? Yes. The following are some of the steps; I have taken in doing so:1) Definitely take a back up of the whole project(s) by exporting the project as a .dsx file2) See that you are using the same parent
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
