Reading the sequential file
Posted: Fri Sep 07, 2012 3:46 am
Hi All,
I have source file say file.csv where it contains following data
Empno, Deptno
12,1
13,1
23,2
45,3
now my requirment is when i read this file in datastage it should read only the records where Deptno=1,2...not every time 1 and 2 the Deptno will keep on changing.
I am thinking that i will create a file in unix for which Deptno should process the read the records mentioned in below file.
like dept.txt contains 1,2
Can i use the file in datastage to read only the deptno mentioned in the file. is it possible ot how can achieve this.
Pavan
I have source file say file.csv where it contains following data
Empno, Deptno
12,1
13,1
23,2
45,3
now my requirment is when i read this file in datastage it should read only the records where Deptno=1,2...not every time 1 and 2 the Deptno will keep on changing.
I am thinking that i will create a file in unix for which Deptno should process the read the records mentioned in below file.
like dept.txt contains 1,2
Can i use the file in datastage to read only the deptno mentioned in the file. is it possible ot how can achieve this.
Pavan