If you want to use the same piece of code in different jobs, how will you achieve it?
No Answer is Posted For this Question
Be the First to Post Answer
where we use column generator stage in real time scenario?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are the different database update actions available?
How to remove blank spaces from data?
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
What are the different options associated with dsjob command?
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
What is "fatal error/rdbms code 3996" error?
when we have to go for a sequential file stage & for a dataset in datastage?
How to use Environment variable's in datastage?(use of process)
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do