1) 4-way input file with 0 record pass to Rollup with null key what should be the output? - 0 records
2) 4-way input file to Rollup with null key what should be the output? - 4 output records for each partition.
3) What is Max core?
https://abinitioreinvention.blogspot.com/2021/09/max-core-for-abinitio-components.html
4) In which component we are getting the max core parameter? - Rollup, Join, sort
5) Can we change the value of the max core parameter?
https://abinitioreinvention.blogspot.com/2021/09/max-core-for-abinitio-components.html
6) SCD type 2?
https://abinitioreinvention.blogspot.com/2021/07/scd2-implementation.html
7) Scenario -
Name Item
Anjali Bike
Anjali Car
Anjali cycle
Snehal Bike
Output -
Name Bike_flag Car_flag Cycle_flag
Anjali Y Y Y
Snehal Y N N
Input file - Rollup - Reformat - Rollup - output file
Rollup -
Key - Name ,Item
out::rollup(in)=
begin
out.name::in.name;
out.Bike_flag::accumulation(in.Items);
out.Car_flag ::accumulation(in.Items);
out.Cycle_flag::accumulation(in.Items);
end
Reformat-
out.name ::in.name;
out.Car_flag::length_of(vector_select(in.Car_flag,'Car'));
out.Bike_flag::length_of(vector_select(in.Bike_flag,'Bike'));
out.Cycle_flag::length_of(vector_select(in.Cycle_flag,'cycle'));
Rollup -
Key - Name
8) Employee table - increase the salary of an employee by 10% whose salary will be greater than 50000 and Department Is IT.
UPDATE employees SET salary= salary + (salary * 10 / 100) WHERE salary > 50000 and dept='IT';
9) list down the m_ command ?
m_rollback,m_dump,m_cat,m_touch,m_cat,m_ls,m_rm,m_expand,m_mv,m_cp
10) Checkin command?
https://abinitioreinvention.blogspot.com/2021/08/abinitio-important-air-commands_18.html
11) Input -
ANJALI
Output -
A
AN
ANJ
ANJA
ANJAL
ANJALI
I/p- Normalize-O/p
Normalize -
out::length(in)=
begin
out::length_of(in.id);
end;
out::normalize(in,index)=
begin
out.id::string_substring(in.id,1,index+1);
10) Can we use the m_dump command for a serial file?
Yes, we use m_dump command for serial and multi files.
No comments:
Post a Comment