Unix Questions-2

Question 4. How to configure informatica at UNIX level?
Answer: Awaiting for the answer

Question 5: Alternative of grep command
Answer: awk, sed

Question 6: How to delete a file in Unix
Answer: rm -r <filename>

Question 7: How to connect to a Data base in Unix
Answer:  $ sqlite3 <dbname>        [ This will connect to data base ]

    sqlite> select * from dual;
    sqlite> .import <dumpfile> <tablename>

Unix Questions

Question 1:Without opening in vi mode , replace a particular string.

Answer: It can be done by using 'sed' command in UNIX
The wikipedia link is given below

sed on Wikipedia

Example:
 sed -e 's/oldstuff/newstuff/g' inputFileName > outputFileName

Question 2: How to hold a workflow by a UNIX command.
Answer:
 'wait' command can do the job

Though 'sleep' command can can make a job to wait for a particular time
e.g. ->    sleep 5
This will sleep the job for 5 seconds

e.g of wait command:
wait [pid] [jobid]

pid= process id
jobid=job id

Question 3: How to display the 10th line of a file and last 2 lines in one command?
Answer: Awaiting for the answer

This blog addresses the questions related to ETL testing

This blog addresses the questions related to ETL testing.

It will have mainly three parts:

1. SQL
2. ETL Tools ( like Informatica mainly )
3. Unix

And some generic questions.