Kannan Chandrasekaran's Page

Amit Nimje Infocepts replied to Kannan Chandrasekaran's discussion what are Queries (SQL) used in ETL testing

"Hi , In ETL testing you need to compare source to target data comparison. So sample queries on Source Data is - 1) select count(*) from SourceTable where id is not null And Target table query will be- 2) select count(*) from SourceTable…"

May 14

Naveen replied to Kannan Chandrasekaran's discussion what are the software need to install in the machine for automate the application using selenium

"older versin is rc new version is web driver"

Apr 23

Sandeep Fofandi replied to Kannan Chandrasekaran's discussion what are the software need to install in the machine for automate the application using selenium

"Which one is good ? WebDrive or RC? "

Apr 23

Kirtesh Wani replied to Kannan Chandrasekaran's discussion what are the software need to install in the machine for automate the application using selenium

"Basically you need to decide whether you want to use webdriver with Java or .Net Technology For Java you will need following software Ecilipse WebDriver Latest Jars For .Net you will need following Visual Studio (Express is Free) WebDriver DLL "

Apr 23

Kannan Chandrasekaran posted discussions

Apr 22

shruti chaudhary replied to Kannan Chandrasekaran's discussion What is refrential Integrity ?

"[01-03-2013 16:03:29 | Edited 16:03:41] Shruti Chaudhary: Refrential integrity is used to maintain consistency amongst two tables . for Ex Consider two tables in a same DB , employee E and dept D . Dept table has a dept_id column Employee table has…"

Mar 4

Kannan Chandrasekaran is now friends with varunvilla, raghunath and Vadivelan

Jan 7

Kannan Chandrasekaran replied to Sandeep Fofandi's discussion Client sent bug but all testcases are passes then how can convience to developer?

"Hi, first we analysis the bug , what Type of bug it is either functional /performance/GUI or Change Request We set the priority to the Bug first we explain bug to developer and reproduce the bug in testing environment try to reproduce the bug…"

Nov 22, 2012

Rohit Agrawal replied to Kannan Chandrasekaran's discussion What is Surrogate Key ?

"Hi Kannan, Surrogate key is a sequence generator(mostly numeric) which is embedded into the dimension table to identify a unique row. It is most important when you are implementing slowly changing dimension concept (generally type 2 and type 3) when…"

Nov 8, 2012

bathwalshaili replied to Kannan Chandrasekaran's discussion What is Surrogate Key ?

"Hi Kannan, Surrogate key is used to identify each row uniquely. It is also known as artificial or identity key. The surrogate key is system generated artificial primary key and has a defined incremental value for each row in a table. Surrogate key…"

Nov 7, 2012

Kannan Chandrasekaran posted a discussion

What is refrential Integrity ?

refrential IntegritySee More

Nov 6, 2012

1 Comment 0 Likes

Neil Aakash replied to Kannan Chandrasekaran's discussion What is Surrogate Key ?

"There are two definitions of a surrogate: Surrogate (1) – Hall, Owlett and Codd (1976) A surrogate represents an entity in the outside world. The surrogate is internally generated by the system but is nevertheless visible to the user…"

Nov 5, 2012

Suresh S replied to Kannan Chandrasekaran's discussion Please Share the Query please

"You can minus query between source and target,then you can get the names which are diff from target. select cust_name from SRC.Custsomer_info MINUS select cust_name from Customer_info. here SRC is yr sorce databse name and give a grant…"

Oct 30, 2012

Kannan Chandrasekaran replied to tarique ahmed khan's discussion What is ETL testing

"Hi ,, ETL : ETL stands for Extract Transformation and Load, It collect the different source data from Heterogeneous System (DB), Transform the data into Data warehouse (Target) At the Time of Transformation, Data are first transform to Staging Table…"

Oct 30, 2012

Kannan Chandrasekaran posted a discussion

Please Share the Query please

I across the below question in ETL Testing interviewobjective : write the query to find the difference from Source DB- table name(custom_info)and Target db ,table name (custom_info)Custom_idCustom_nameCustom_ageCustom_dob25anith2321/12/201424Kumar2221/12/201323Raj2121/12/201226Rahul2421/12/2015DatabaseTargetTable NameCustomer_infoDatabase SouceTable NameCustomer_infoCustom_idCustom_nameCustom_age|Custom_dob23Raj21|21/12/201224Kumar22|21/12/201325anith23|21/12/201426Rahul24|21/12/2015 See More

Oct 25, 2012

1 Comment 0 Likes

Alligatortek replied to Kannan Chandrasekaran's discussion Please Post the 'Test Specifcation Document '

"Hi Kannan, U can refer the attached document, it may give u a idea about test specification. By, www.alligatortek.com"

Oct 16, 2012

Kannan Chandrasekaran's Friends

Kannan Chandrasekaran's Groups

Agile Testing

Database Testing

VB Scripting

Software Testing Projects

SDLC

Kannan Chandrasekaran's Discussions

what are the software need to install in the machine for automate the application using selenium

what are Queries (SQL) used in ETL testing

What is refrential Integrity ?

Please Share the Query please

Kannan Chandrasekaran's Page

Latest Activity

what are the software need to install in the machine for automate the application using selenium

what are Queries (SQL) used in ETL testing

What is refrential Integrity ?

Please Share the Query please

Profile Information

Kannan Chandrasekaran's Photos

Comment Wall (3 comments)

You need to be a member of Quality Testing to add comments!

TTWT Magazine

Welcome to Quality Testing!

Advertisement

Submit A Job

Submit A Tool

Advertisement

Videos

Android Automation with Cucumber

Using page-object with RSpec

Badge