Viewing 9 posts - 1 through 9 (of 9 total)
Thank you.This is pretty close.
December 21, 2016 at 7:21 am
i wanted to stop the file from loading into DW if the status of file is "rejected" and set up error message and notification ,given the criteria above in...
December 20, 2016 at 10:26 am
exactly...and now i added new column to new table and need to add the percentage of those two counts
(count1*1.0)/(count2)...this needs to happen for every file load i do once...
December 15, 2016 at 1:06 pm
Thanks for the reply.
I alreaady had this kind of insert statement but here in my case i have to enter count of records from good data table T1 and bad...
December 15, 2016 at 12:26 pm
ok.Let me give correct example.
Key is 000SAQD11114165846563 and 000IDP1111112555555
While loading from flat file i have to check
1.if the len(key)>10(this i can do)
2. and if(susbtring(key,1,6)='000IDP') then check for the 13th...
December 12, 2016 at 9:13 am
Hi All,
I got a requirement to load 40+ flat files in staging table along with file date and file name for each file.I could use for each loop to load...
June 16, 2016 at 3:59 pm
Hi All,
i have same requirement of creating multiple pdf files based on each parameter value from a single report.I have heard of doing this through c#code.Could anyone post a complete...
February 25, 2016 at 3:08 pm
Viewing 9 posts - 1 through 9 (of 9 total)