| Author |
Message |
![]() ![]() ![]() ![]()
Monk
Comedian Username: Monk
Post Number: 1630 Registered: 10-2013 Posted From: 155.98.164.38
Rating: N/A Votes: 0 (Vote!) | | Posted on Monday, January 22, 2018 - 10:57 am: |
![]() ![]() ![]() ![]() ![]() |
Gochi:Data Match: Counts kaakundaa data kooda check cheyyaaligaa...each field lo what is your input value, what is your output value? Are all the business rules being applied(transformed) correctly? Basic gaa 'Minus' query between source and target. Vaadu ETL lo chesina daanni meeru oka querygaa raasukuni minus chesi choodandi...malli ee query ETL developer ni adagakandi, vaadu chesindhe meeku isthaadu Data Format: Do you need a decimal? Rounding? Strings, anything getting truncated etc etc...basic gaa data types.. Job setup: How will this ETL job run? If they are using Control M, test and make sure job is successful. Do you have any file watchers, like automatic run of job as soon as file is placed in source location? Do you have dependencies on any other job for this ETL job, test this? Do you need to log any errors, are the rejected records being logged correctly into error tables? Is there any hard coding done for any environment/data connections? Is the process automated end to end?
thank you so much annai for info. Makada anni meme sesukovali DM design kada nunchi reporting dhaka. ETL validation gurinchi no idea apart from counts and business logic validation. Tracking vunna chota week tracking leni chota stronge………. |
![]() ![]() ![]() ![]()
Gochi
Side Hero Username: Gochi
Post Number: 3185 Registered: 12-2006 Posted From: 159.53.110.144
Rating: N/A Votes: 0 (Vote!) | | Posted on Monday, January 22, 2018 - 10:37 am: |
![]() ![]() ![]() ![]() ![]() |
Monk:oka dharma sandeham, ETL testing ante em sestahru apart from counts.
Data Match: Counts kaakundaa data kooda check cheyyaaligaa...each field lo what is your input value, what is your output value? Are all the business rules being applied(transformed) correctly? Basic gaa 'Minus' query between source and target. Vaadu ETL lo chesina daanni meeru oka querygaa raasukuni minus chesi choodandi...malli ee query ETL developer ni adagakandi, vaadu chesindhe meeku isthaadu Data Format: Do you need a decimal? Rounding? Strings, anything getting truncated etc etc...basic gaa data types.. Job setup: How will this ETL job run? If they are using Control M, test and make sure job is successful. Do you have any file watchers, like automatic run of job as soon as file is placed in source location? Do you have dependencies on any other job for this ETL job, test this? Do you need to log any errors, are the rejected records being logged correctly into error tables? Is there any hard coding done for any environment/data connections? Is the process automated end to end? |
![]() ![]() ![]() ![]()
Monk
Comedian Username: Monk
Post Number: 1628 Registered: 10-2013 Posted From: 155.98.164.38
Rating: N/A Votes: 0 (Vote!) | | Posted on Monday, January 22, 2018 - 10:23 am: |
![]() ![]() ![]() ![]() ![]() |
ETL testers, oka dharma sandeham, ETL testing ante em sestahru apart from counts. Tracking vunna chota week tracking leni chota stronge………. |
|