If your source is a cobol copybook, then we have a command in unix which generates the required in Ab Initio. here it is:
cobol-to-dml.
skew is the mesaureof data flow to each partation .
suppose i/p is comming from 4 files and size is 1 gb
1 gb= ( 100mb+200mb+300mb+5oomb)
1000mb/4= 250 mb
(100- 250 )/500= --> -150/500 == cal ur self it wil come in -ve value.
calclu for 200,500,300.
+ve value of skew is allways desriable.
skew is a indericet measure of graph.
Rollup is for group by and Scan is for successive total. Basically, when we need to produce summary then we use scan. Rollup is used to aggregate data.
m_dump command prints the data in a formatted way.
m_dump <dml> <file.dat>
EME is a repository in Ab Inition and it used for checkin and checkout for graphs also maintains graph version.
Webmaster 25th of May 2013
Tell us what you feel about Ab Initio Data Warehousing Interview Questions and Answers
All comments will be published after review. No login or registration is required to post a comment on Ab Initio Data Warehousing Interview Questions and Answers We offer and invite you to submit your valuable comment now; Please be respectful of others when commenting. Insulting others, self-promotional comments, website promotional comments, marketing stuff, SEO Techniques, SMS-style content and off-topic comments will not be approved at this information portal.
So start sharing your thoughts regarding Ab Initio Data Warehousing Interview Questions and Answers
Thank you.