My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

Prashant

• Nov 25th, 2018

If your output file is sequential file then you can you use filter property .

Prashant

• Nov 25th, 2018

If the input has 2 partion then i would get 2 rows for lastrow() function. rest everyhing is correct

Answer Question  Select Best Answer

i have a source file1 consist of two datatypes file1: no(integer) 1 2 3 & dept(char) cs it ie and i want to seperate these two datatypes and load it into target files file2 & file3. how can i do this in datastage and by using which stage?

lalit

• Oct 10th, 2017

So you can do it with transformer constraints like
allnum(), alpha() like function and separate both datatypes in two different outputs

dileep Janga

 Profile Answers by dileep Janga Questions by dileep Janga

• Jan 31st, 2014

I think this Question is to confuse the Job Aspirant by using Datatypes and all... Its very simple... File1-->2 Columns. 1.NO(Integer) 2.DEPT(Char). Target1: NO(Integer), Target2: DEPT(Char). Take ...

Answer Question  Select Best Answer

Ishu

• Feb 20th, 2015

Use of parameters: 1. avoid hardcoding. 2. Incase a value for some parameter is changed in future, we can change it at a single point instead of making changes everywhere in every job wherever it is ...

Lubna Khan

• Jan 27th, 2014

By Using Parameters we can avoid hardcoding and assign values at runtime

Answer Question  Select Best Answer