How we will implement scd in DS?Explain with example ?Any scd ie scd1,scd2,scd3 .
Latest Answer: If you are using Server version, you will have to use a combination of transformer, hashfiles for lookup and stage variables. If you are using the parallel version you will have touse the Change Capture and Change Apply stages ...
How can i load a flat file into target as fast as i can?Assuming that the source bottleneck is not there,that is there is no performance issues in the source side.
in datastage job successfully finished. but showing errors in director window. How do we fix and find the cause for the errors
Latest Answer: I think in designer u find the green colour but in Director -> log view --> u find some fatal errors and job is aborted, is it, Means job is successfully completed but the data is not loaded in to the target, may be some miss matched data, datatype ...
in how many ways we can delete dataset? If a record is duplicated 3 times then how to get middle duplicated record? Is it advisable to use basic Tfr in Parallel jobs?
Latest Answer: w/o basic t/r also we can do this know, then y to use basic t/r here. ...
What are the different Debug stages available in Datastage PX?
Latest Answer: head, tail, rowgenerator,columngenerator,peek,sample, write range map . ...
When you are able to handle Null handling and Data type changes in ODBC stages why you need Modify Stage?
Latest Answer: Modify Stage is used for the purpose of Datatype Change. ...
What is Pipeline Parallelism in Datastage?
Latest Answer: here each satge will work on separate processor ...
Hi friends, i know while using lookup stage if the lookup table has huge amount of data we will go for sparse lookup or else will use normal lookup. would anybody explain how the memory will be allocated
Latest Answer: "Hi friends, i know while using lookup stage if the lookup table has huge amount of data we will go for sparse lookup or else will use normal lookup. would anybody explain how the memory will be allocated for both type of lookups?" First ...
i am running huge amount of data through a sort stage and it is very slow. Is there any option which can increase the performance with in the sort stage?
Latest Answer: See if it is orcle db then u can write user def query for sort and remove duplicates in the source itself. and maintaining some key partition teqniques u can improve the performence. If it is not the case means better go for some key partion teqniques ...
Can anyone tel me how to use a file to fetch the parameter values for a parallel job in datastage as i don't want it to be hard coded.The format for the file shall be (name,value) pair. please help
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
