Latest Answer: What type of index are you looking for ? If it is only based on rows, use @inrownum or @outrownum ...
Latest Answer: What is ur source?. Depending on type of source, you have to use respective stage.like oracle enterprise: u can use this for oracle source and target.similarly for other sources.Hanu. ...
Latest Answer: There are two methods for eleminating duplicate rows in datastage1. Using hash file stage (Specify the keys and check the unique checkbox, Unique Key is not allowed duplicate values)2. Using Sort stage by link remove duplicate stageThanx ...
Latest Answer: First of all thanks to srilaxmi for your skill in pivot stage.Pivot stage supports only horizontal pivoting – columns into rowsPivot stage doesn’t supports vertical pivoting – rows into columnsExample: In the below source table there are two cols about ...
1 1. Difference between Hashfile and Sequential File?. What is modulus?2 2. What is iconv and oconv functions?.3 3. How can we join one Oracle source and Sequential file?.4 4. How can we implement Slowly Changing Dimensions in DataStage?.5 5. How can we implement Lookup in DataStage Server jobs?.6 6. What are all the third party tools used in DataStage?.7 7. what is the difference between routine and transform and function?.8 8. what are the Job parameters?.9 9. Plug-in?.10 10.How can we improve
Latest Answer: You have to write routine in C++ (g++ in Unix). then you have to create a object file. provide this object file path in your routine. ...
I have few questions1. What ar ethe various process which starts when the datastage engine starts?2. What are the changes need to be done on the database side, If I have to use dB2 stage?3. datastage engine is responsible for compilation or execution or both?
Latest Answer: hiThe differerence between reference link and straight link isThe straight link is the one where data are passed to next stage directly and the reference link is the one where it shows that it has a reference(reference key) to the main tablefor example ...
How we use the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting e/xecutable versions on ad hoc or scheduled basis?
View page << Previous 10 11 12 13 [14] 15 16 17 18 19 Next >>
Go Top
