Scanning the Dataset
Posted: Mon Apr 05, 2010 4:32 am
Hi,
I have 100+ Jobs in my project. If i want to debug for a particular record then iam scanning each and individual job to see where the record got dropped exactly. If iam the developer of those 100 Jobs then i can identify the exact job with some assumption since i know the business requirement.
But my requirement is, i want to identify the list of dataset which holds the searching string.
Example:
Dataset1: MEM1 DATE1
Dataset2: MEM1 DATE1 GENDR1
********MEM2 DATE1 GENDR2
Dataset3: MEM1 DATE1 GENDR1 ST1
********MEM2 DATE1 GENDR2 ST1
Dataset4: MEM2 DATE1 GENDR2 ST1
Dataset5: MEM2 DATE1 GENDR2 ST1
********MEM3 DATE1 GENDR2 ST1
Dataset6: MEM1 DATE1 GENDR2 ST1
********MEM3 DATE1 GENDR2 ST1
Dataset7: MEM1 DATE1 GENDR2 ST1
********MEM4 DATE1 GENDR2 ST1
Search String: MEM1
My Output Should be below:
Dataset1
Dataset2
Dataset3
Dataset6
Dataset7
Thanks.
I have 100+ Jobs in my project. If i want to debug for a particular record then iam scanning each and individual job to see where the record got dropped exactly. If iam the developer of those 100 Jobs then i can identify the exact job with some assumption since i know the business requirement.
But my requirement is, i want to identify the list of dataset which holds the searching string.
Example:
Dataset1: MEM1 DATE1
Dataset2: MEM1 DATE1 GENDR1
********MEM2 DATE1 GENDR2
Dataset3: MEM1 DATE1 GENDR1 ST1
********MEM2 DATE1 GENDR2 ST1
Dataset4: MEM2 DATE1 GENDR2 ST1
Dataset5: MEM2 DATE1 GENDR2 ST1
********MEM3 DATE1 GENDR2 ST1
Dataset6: MEM1 DATE1 GENDR2 ST1
********MEM3 DATE1 GENDR2 ST1
Dataset7: MEM1 DATE1 GENDR2 ST1
********MEM4 DATE1 GENDR2 ST1
Search String: MEM1
My Output Should be below:
Dataset1
Dataset2
Dataset3
Dataset6
Dataset7
Thanks.