When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
1138Describe 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)?
1146
Explain the ab initio etl tool in high level?
Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low
What is a data processing cycle and what is its significance?
Define ramp limit in ab initio?
Why might the optimizer use a table scan when an index is available?
What is a local lookup?
Explain what is de-partition in abinitio?
Mention some file extensions which are used in abinitio?
What are the benefits of data processing according to you?
Do you think effective communication is necessary for data processing? What is your strength in terms of same?
How you can run a graph infinitely in ab initio?
What is the role of co-operating system in abinitio?
Mention what is rollup component?
explain the environment varaibles with example?
i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?