@@@@calling All Datastage Developers@@@@

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 :3D_Smiles_349:

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

November 22, 2012

Config file ni apt comfig ani vuntadi env variable anukuna adi us chesi change cheyochu

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

November 22, 2012

Parallelism portioning material lo vuntadi mama

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]

))(<

November 26, 2012