guna
Posted: Wed Feb 09, 2005 5:07 am
routines:
1)How to use routines in datastage?
2)Have you are written any custom routines in your project? is so explain?
3)how to make read - only routines in datastage? it possible if so how?
4)what are different field operators in routines?
stages
1)what is difference between shared-container and local-container?when comparing this with informatica a shared container is mapplet or re-usable tranformation?
2)if ur are changing any changes in shared-container will it effect in all the jobs were you used this shared- container?
3)how can u set properties of hashed file(that is caliculatins of minimum modules etc..)?
4)what is the architecture of datastage?
5)can u use in/out parametres in odbc?
6)what is stage variables,system variables,environment varaibles?
7)suppose if i have 150 colums in source and data in that is 1 million records suppose
if colum1 some values i want to replaces to some values like that i need to change for fifty
colums how can i change them?
8)can i join a flat file and oracle and load into oracle?is this possible?
9)how can u do incremental aggregation in datastage? if so how?
10)while loading some data into target suddenly thier is a problem loading process
stopped how can u start loading from the records that were left?
......................
1)in informatica the repository is in rdbms? where the repository in datastage resides?
ans)universe rdbms,but if you want to increase the repository size
how can u alter that in datastage,in informatica if repository is
oracle u can alter that by alter command at prompt for that particular database
........................
1)what are the general problems that u face in datastage?
2)
[/i][/b]
1)How to use routines in datastage?
2)Have you are written any custom routines in your project? is so explain?
3)how to make read - only routines in datastage? it possible if so how?
4)what are different field operators in routines?
stages
1)what is difference between shared-container and local-container?when comparing this with informatica a shared container is mapplet or re-usable tranformation?
2)if ur are changing any changes in shared-container will it effect in all the jobs were you used this shared- container?
3)how can u set properties of hashed file(that is caliculatins of minimum modules etc..)?
4)what is the architecture of datastage?
5)can u use in/out parametres in odbc?
6)what is stage variables,system variables,environment varaibles?
7)suppose if i have 150 colums in source and data in that is 1 million records suppose
if colum1 some values i want to replaces to some values like that i need to change for fifty
colums how can i change them?
8)can i join a flat file and oracle and load into oracle?is this possible?
9)how can u do incremental aggregation in datastage? if so how?
10)while loading some data into target suddenly thier is a problem loading process
stopped how can u start loading from the records that were left?
......................
1)in informatica the repository is in rdbms? where the repository in datastage resides?
ans)universe rdbms,but if you want to increase the repository size
how can u alter that in datastage,in informatica if repository is
oracle u can alter that by alter command at prompt for that particular database
........................
1)what are the general problems that u face in datastage?
2)
[/i][/b]