|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions When using multiple DML statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why. Describe the elements you would review to ensure multiple scheduled "batch" jobs do not "collide" with each other. Describe how you would ensure a T-SQL script ran on a particular database where there are multiple databases on a single server. Describe how you would ensure that database object definitions (Tables, Indices, Constraints, Triggers, Users, Logins, Connection Options, and Server Options etc) are consistent and repeatable between multiple database instances (i.e.: a test and production copy of a database). Sift links to MFS files on Unix for Ab Initio ? what is this ....2) $pound what is this 3) $? what for it is used 4) types of loading 5 overwrite when it used ? Latest Answer : Load multiple files from my perspective means writing into more than one file at a time. If this is the same case with you, Ab initio provides a component called Write Multiplefiles (in dataset Component group) which can write multiple files at a time. ... Read Answers (2) | Asked by : gadhuly I am having a control file which consists of 4 mfs files, I want to add other 4 files to the same control file, how can i do and how to convert it into a directory? Read Answers (1) | Asked by : murali Ab Initio Interview questions compiled. Someone please answer them. It will help all of us here.1) What is the difference between dbc and cfg? When do you use these two?2) What are the compilation errors you came across while executing your graphs?3) What is depth_error?4) During the execution of graph, let us say you lost the network connection, would you have to start the process all over again or does it start from where it stopped?5) Types of partitions and scenarios.6) What does unused port View Question | Asked by : ss Hello all Ab Initio developers,I have recently graduated and I have just joined the Data Warehousing Hello all Ab Initio developers,I have recently graduated and I have just joined the Data Warehousing profession, I got some basic training in Ab Intio for few months now and have a few questions, can someone please help me. 1) How does parallelism work in Ab Initio? When and how do you decided when to use the different types of parallelism?1. Component -- multiple components running on SEPRATE data at the SAME time.2. Pipe-line -- Multiple components running simultaneously on SAME data at the If I have 2 files containing field file1(A,B,C) and file2(A,B,D), if we partition both the files on key A using partition by key and pass the output to join component, if the join key is (A,B) will it Latest Answer : .dbc : Database Connectivity - In input table specify db version, host location, user name, password etc..cfg : Server Connectivity ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
