What is Ad-Hoc access? What is the difference between Managed
Query and Ad-Hoc
access?
No Answer is Posted For this Question
Be the First to Post Answer
What is mapping?
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
If you want to use the same piece of code in different jobs, how will you achieve it?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.
What are the functionalities of link partitioner and link collector?
What are datastage sequences?
what is the best stage in datastage parller jobs to use full out join and why
How can we improve the performance in datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
what is main difference between change capture and change apply stages
1.what is materialized data? 2.how to view the materialized data?