1. Compare two string and get all the matching character.
2. Compare current and last version of code
3. m_db load and unload command
4. What breaks the data parallelism.
5. Create 10 files of 1 gb each
Ans: dd if=/dev/zero of=testfile bs=1024 count=1024000
You can find on other forum that they use /dev/urandom or /dev/random however this
are load intensive for your server and take longer to make the file.
6. Difference between ${} and $ in parameter definition in abinitio. (Doubt)
Ans: ${} lets you use non param name which has $ in its name.. That’s the only
difference and usage
7.
Decimal (2,2)
Decimal (2,0)
And
Decimal (2.2)
Decimal(2.0)
Difference
Plz try this
M_eval(str_ltr(' ' ))
What would be the output
Here we are passing space in STR LTR function
Ans: m_eval 'string_lrtim((" ")' --> ""
[1/9, 3:54 PM] : 1. What is 3NF ?
2. What is Factless Fact ?
3. What is SCD1 and SCD2 ?
4. What is CDC ?
5. Give syntax and options of air tag create
6. Give options of m_dump
7. How to use air project export and air project import ?
8. How to use air promote save
9. What is AB_DML_DEFS ? How to use it ?
10. What is Block Expression in PDLs? How to use it ?
11. Rollup with Null Key
12. Dedup Sort
13. In memory Join functionality
14. In memory Rollup functionality
15. What is AB_CATALOG ?
16. What is Dependency Analysis ?
Unix : sed, grep, find
Vi Editor : How to go to end of Line, How to go to end of file, How to search and
replace a pattern
Database - Remove duplicates from a table, nth highest salary, ( rank, dense rank,
row number difference)
DWH - Surrogate Key
qus Run Time Behavior of all below components is very very Important :
1. Join
2. Rollup
3. Scan
4. Reformat
5. Normalize
6. Sort
7. Dedup Sort
qus .project.ksh
.project-start.ksh
.project-end.ksh
Use of start script and end script in graphs
qus What is AI_GRAPH_MAX_CORE ?
What is Dynamic Script Generation ?
qus In memory vs Sorted
qus What is AI_GRAPH_MAX_CORE ?
What is Dynamic Script Generation ?
qus Third Normal Form kya hota hai
qus 1. Read and Write Multiple files
2. Normalize
3. Reject ... Ramp and Limit
4. Dependency Analysis
qus BRE, ACE and Metadata Hub kya hota hai ... just definition and use ...
qus Metaprogramming Functions :
1. Read_type
2. Read_file
3. Allocate_with_defaults
4. Reinterpret_as
5. Test_characters_all
6. String_convert_explicit
7. File_information
8. Directory_listing
qus How to use key change function ?
Input
Balls Runs
1 1
2 2
3 4
4 6
5 0
6 1
1 4
2 4
3 4
4 0
5 0
6 6
Output should be
Overs Runs
1 14
2 18
qus Facts and Dimensions
qus Use of below functions in Rollup Component
1. accumulation
2. Input select param
3. Output select param
qus Star Schema and Snow Flake Schema
qus SCD1 and SCD2
qus CDC
qus Factless FACT
qus Surrogate Key
qus Express>IT
Conduct>IT
Query>IT
qus How it is different from Primary Key ?
qus Attributive Entity
Associative Entity
Major Entity
ER Diagram
3NF
qus Agile methodology
Devops
ACE
BRE
Metadata Hub
qus Yeh sab kya hai woh padh lena
qus Star Schema and Snow Flake Schema acche se padh lena
qus Header
Body
Trailer
Separate them
And validate count from trailer
qus These concepts u shd know even though u hv nt worked on them
qus Use of Rollup and Fuse
qus Air promote save ---- air object save ---- create save file
qus Remove last 10 lines from a file in unix
qus Private
Public
Common sandbox difference
qus Public means ... generics which can be used across all private projects if
included as common project
qus Common means ab_env, std_env etc
qus Unix script ki first line mein kya likhte hain ?
qus .profile mein kya hota hai
qus Do we checkin .sandbox.pset ?
qus .abinitiorc mein kya hota hai
qus #!/bin/ksh
qus What does this mean ?
qus How to transfer multifile from one server to another ?
qus M_dump -select
qus Adhoc multifile - How to use this in abinitio
qus BRD
FRD
LLD
HLD
qus SDLC ?
qus Agile methodology ?
qus ------ Ask him to prepare these topics before appearing for interview
