on how many columns we can perform aggregation in the
aggregator stage?
Answers were Sorted based on User's Feedback
In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?
what is data mapping
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
what are the errors,warnings in datastage
How did you reconcile source with target?
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?
How do u call shellscript/Batch file from DS?
what r the stages mostly used in realtime scenarios
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?