What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
303Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999
238
Describe the grant/revoke ddl facility and how it is implemented?
Mention what is a partition and what are the different types of partition components in abinitio?
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
What is the function that transfers a string into a decimal?
What do you know about partition and also tell us about partition components in abinitio?
How you can run a graph infinitely in ab initio?
Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999
What is $mpjret?
Have you ever encountered an error called “depth not equal”?
What would be the next step after collecting the data?
What are the six data process products of ab initio (architecture of ab initio)?
What do you mean by a transaction file?
Describe what the SQL Server tempdb and tlog files are used for?
Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?
What is the difference between rollup and scan?