Topics | Search Log Out | Register | Edit Profile
Hide Clipart | Banned/Unbanned User Log | Moderator Login History | Thread Delete/Move Log | Last 30 mins | 1 | 2
Any ETL Testers in DB

Chalanachithram.com DB » New TF Industry Related » Archive through January 22, 2018 » Any ETL Testers in DB « Previous Next »
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……….

Add Your Message Here
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image HASH(0x843d4a0){Movie Clipart}
Show / hide regular icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Show / Hide Filmy icons selection options

Click on following links to open cliparts by Alphabetical Order

  A   B   C   D   E   F   G   H   I   J   K   L   M  

N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Username: Posting Information:
This is a public posting area. Enter your username and password if you have an account. Otherwise, enter your full name as your username and leave the password blank. Your e-mail address is optional.
Password:
E-mail:
Options: Enable HTML code in message
Automatically activate URLs in message
Action: