- 
	
	
		
			
			
				Junior Member
			
			
			
			
				
					
						  
 
					    
				 
 
			
				
				
				
					Datastage
				
					
						
							Hi..
 I'm learning ascential data stage now.
 I want to know how and where in data stage designer(transformer)
 I should generate the surrogate key for emp no field.
 
 Also I want to know the function for new line \n.
 
 thanks
 sangeetha
 
 
 
 
 
 
 
 
 
- 
	
	
		
			
			
				Junior Member
			
			
			
			
				
					
						  
 
					    
				 
 
			
				
				
				
					 Sorrogate Key Sorrogate Key
					
						
							Hi Sangeeta,
 
 What version of datastage you are using.
 
 if it 7.5.1a then there is no sorragate key generator, so we need to use stage variable, so that it generate maually every time you insert new record.
 
 try stage variable.
 
 if you still have problem, let me know i will sent screeen shot which will help you.
 
 
 
 
 
 
 
 
 
 
	
	
	
	
	
	
	
	
	
	
	
	
		
		
			
				 Posting Permissions
				Posting Permissions
			
			
				
	
		- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-  
Forum Rules