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

Why is it necessary to clean data before loading it into the Warehouse

Prashant Khare

• Oct 3rd, 2012

Data Cleansing is a process of detecting and correcting the corrupt and inaccurate data from table or database.
There are following steps used:-
1) Data auditing
2) Workflow Specification
3) Workflow Execution
4) Post-processing and controlling

32kris

 Profile Answers by 32kris Questions by 32kris

• Aug 11th, 2010

Cleaning is required as it helps in maintaining the uniforminty of the target data.

Answer Question  Select Best Answer