qwerty1204 Posted November 22, 2012 Author Report Share Posted November 22, 2012 [quote name='Silver_mani' timestamp='1353537396' post='1302837948'] these were some of the very basic questions i asked while interviewing for DS Junior Dev position[list=1] [*]Main differences between server edition (up to version 7.5) and enterprise edition (from version 8.0) [*]Difference between join, lookup and merge stages [*]What kind of joins does the 2 options in lookup stage – Continue , drop specify ? [*]Name some of the restructuring stages in datastage [*]What stage do you use in datastage to convert columns in to rows [*][b]Difference in using link sort and sort stage[/b] [*]Different Partioning methods in datatstage .Which portioning method duplicates the data if run on multiple nodes .? [*][b]How would you change Configuration file ?[/b] [*][b]explain parallelism and partitioning in enterprise edition[/b] [*][b]Difference between union and union all[/b] [/list] [/quote] answers plzz Link to comment Share on other sites More sharing options...
pandemkodi Posted November 22, 2012 Report Share Posted November 22, 2012 Huge data vunna data lo duplicates vunna already some keys meeda sort chesi vunna sort stage use Chatham Migilina cases lo link sort use chestam but sorting is expensive so if possible do it from database if u r reading from db stages Link to comment Share on other sites More sharing options...
pandemkodi Posted November 22, 2012 Report Share Posted November 22, 2012 Config file ni apt comfig ani vuntadi env variable anukuna adi us chesi change cheyochu Link to comment Share on other sites More sharing options...
pandemkodi Posted November 22, 2012 Report Share Posted November 22, 2012 Union antey duplicates raavu. Union all antey data Mottam vastadi Ex Data set 1 1 Data st 2 1 2 Result in union 1 2 Result in union all 1 1 2 Link to comment Share on other sites More sharing options...
pandemkodi Posted November 22, 2012 Report Share Posted November 22, 2012 Parallelism portioning material lo vuntadi mama Link to comment Share on other sites More sharing options...
qwerty1204 Posted November 26, 2012 Author Report Share Posted November 26, 2012 [quote name='pandemkodi' timestamp='1353553474' post='1302839288'] Union antey duplicates raavu. Union all antey data Mottam vastadi Ex Data set 1 1 Data st 2 1 2 Result in union 1 2 Result in union all 1 1 2 [/quote] Link to comment Share on other sites More sharing options...
tom bhayya Posted November 26, 2012 Report Share Posted November 26, 2012 [img]http://www.desigifs.com/sites/default/files/venky2.gif?1290195063[/img] Link to comment Share on other sites More sharing options...
tom bhayya Posted November 26, 2012 Report Share Posted November 26, 2012 [img]http://www.desigifs.com/sites/default/files/venky2.gif?1290195063[/img] Link to comment Share on other sites More sharing options...
tom bhayya Posted November 26, 2012 Report Share Posted November 26, 2012 [img]http://www.desigifs.com/sites/default/files/venky2.gif?1290195063[/img] Link to comment Share on other sites More sharing options...
tom bhayya Posted November 26, 2012 Report Share Posted November 26, 2012 [img]http://www.desigifs.com/sites/default/files/venky2.gif?1290195063[/img] Link to comment Share on other sites More sharing options...
tom bhayya Posted November 26, 2012 Report Share Posted November 26, 2012 [img]http://www.desigifs.com/sites/default/files/venky2.gif?1290195063[/img] Link to comment Share on other sites More sharing options...
Silver_mani Posted November 26, 2012 Report Share Posted November 26, 2012 [quote name='Alexander' timestamp='1353918675' post='1302853608'] [img]http://www.desigifs.com/sites/default/files/venky2.gif?1290195063[/img] [/quote] u sfammer vuncle Link to comment Share on other sites More sharing options...
pandemkodi Posted December 5, 2012 Report Share Posted December 5, 2012 IMS to DB2 loading eem stages use cheyyali cheppandi konchem Link to comment Share on other sites More sharing options...
pandemkodi Posted December 5, 2012 Report Share Posted December 5, 2012 cheppandi vayya Link to comment Share on other sites More sharing options...
pandemkodi Posted December 5, 2012 Report Share Posted December 5, 2012 ltt Link to comment Share on other sites More sharing options...
Recommended Posts