What are the partition techniques available in your last
project?
Answer / srinivas
Its purely based on stages witch we have used in the project and some times its depends on the data witch we have from source system.
Like if we use Sort,Aggregator stages will use key based partitions.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the difference between in process and inter process?
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
how to handle null values in sequential file?
how can u connect the client system directly at any time?
there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities
how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
In merge stage can we update the values?
I have a few records all are same structures data, I want to store data in multiple targets how?
Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks
How to display errors in datastage?