shreeram gundu


{ City } pune
< Country > india
* Profession * senior software engineer
User No # 103735
Total Questions Posted # 1
Total Answers Posted # 1

Total Answers Posted for My Questions # 2
Total Views for My Questions # 6209

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 11
Questions / { shreeram gundu }
Questions Answers Category Views Company eMail

Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

TCS,

2 Data Stage 6209



Answers / { shreeram gundu }

Question { US Technology, 7915 }

source
1123445
I WANT OUTPUT AS
DUPLICATES TO TARGET1 LIKE
TARGET1
1144
NON-DUPLICATES TO TARGET2
TARGET2
235


Answer

Seq(source)------> Transform stage-------> Tgt1
!.........>Tgt2


use substring in transform stage.

Is This Answer Correct ?    0 Yes 11 No