In ETL testing if the src is flat file, then how will you verify the data count validation?

Divya Jain

• May 16th, 2017

Say file Name: abc.txt and delimited with a comma(,)

answer:
hear -1 abc.txt | awk -F "," {print $NF}

Shivnath Rojatkar

• May 12th, 2017

Using wc command in UNIX, you can check the count of records.

Answer Question  Select Best Answer

Raja

• Jun 12th, 2019

if you have Unix, please use this to command on source and target. (checksum bytecount filename). in the file name pls provide your source file name and once the target is also loded, please provide ...

Ayaskanta Ratha

 Profile Answers by Ayaskanta Ratha Questions by Ayaskanta Ratha

• Nov 17th, 2015

You can union both the minus and then look for the result

Answer Question  Select Best Answer

Can any one let me know where can i find the list of ETL & reporting tolls available in the market. thanks in advance

Prakirn

• Dec 19th, 2020

From performance perspective - Ab Initio
From license cost and market cap perspective - Informatica

shobha

• Mar 20th, 2019

ETL tools are: Informatic power center, Abinition, Data stage, SSIS, ODI

Answer Question  Select Best Answer