How to guess a word in python?

Time again for a game script. How it works This is a classic "guess a word" program.

The word to guess is represented by a row of dashes. If the player guess a letter which exists in the word, the script writes it in all its correct positions.  The player has 5 chances to guess the word. You can easily customize the game by changing the variables.

Code :

Save this program as “Guess the secret word.py” as shown below:

To start the guessing word, enter the user name.

Now the user can start guessing the word by entering characters, as shown below:

Enjoy it!

Implementation of SCD Type-3 in ODI 11g

                    

In SCD type-3, it consists of  two columns to indicate the particular attribute i.e, one indicates the previous value, and the another one indicates the current value.

First in database, duplicate emp table as considered as our target table and we added three  new columns i.e prev sal , curr sal and eff_date as shown below:

 

Create new data server for Source in Oracle Technology

Edit JDBC connections as shown:

Click on test connection

Create new physical schema and logical schema

In the same way create data server, physical and logical schemas for target table in oracle technology

Click on test connection

Now click on designer navigator and create source model

Next reverse engineer the source table

Create a model for target table and reverse engineer

After reverse engineering the source & target tables columns are as follows:

Create new interface and drag & drop the source & target tables on to the interface

Map sal with curr_sal & pre_sal. Edit eff_date to sysdate as shown

And save the interface.

Then import IKM oracle incremental update knowledge module

Now make a copy of  the knowledge module

Rename as scd type3

Go to details & duplicate the 'update existing rows' command & rename it as 'update prevsal with currsal'

Replace codes in command on target tab with the codes given below

Save the edited KM

Now open the interface & click on flow tab & select IKM 'scd type3'

Select flow control as false

Now click on quick edit tab and deselect the insert and update checkboxes and select UD2 user defined flag for pre_sal. Also enable insert, update and UD1 checkboxes for curr_sal as shown:

Then save & run the interface.

Check the loaded date on target table. You can see the PRE_SAL column is blank as this is the 1st run.

Now edit any of the salaries on source side & save. Then run the interface.

Then check the loaded data.

Here you can see the PRE_SAL column updated with 1600 as this is the old salary for ALLEN. Similarly we can change the salary on source side and it will get reflected on target side.

Thus successfully executed scd type3.

Hadoop Commands

Command	What It Does	Usage	Examples
dcat	Copies source paths tostdout.	hdfsdfs -cat URI [URI …]	hdfsdfs -cat hdfs:// <path>/file1; hdfs  dfs -cat file:///file2 /user/hadoop/file3
chgrp	Changes the group association of files. With -R, makes the change recursively by way of the directory structure. The user must be the file owner or the superuser.	hdfsdfs -chgrp [-R] GROUP URI [URI …]
chmod	Changes the permissions of files. With -R, makes the change recursively by way of the directory structure. The user must be the file owner or the superuser.	hdfsdfs -chmod [-R] <MODE[,MODE]... | OCTALMODE> URI [URI …]	hdfsdfs -chmod 777  test/data1.txt
chown	Changes the owner of files. With -R, makes the change recursively by way of the directory structure. The user must be the superuser.	hdfsdfs -chown [-R] [OWNER][:[GROUP]] URI [URI ]	hdfsdfs -chown -R  hduser2 /opt/hadoop/logs
copyFromLocal	Works similarly to the put command, except that the source is restricted to a local file reference.	hdfsdfs -copyFromLocal<localsrc> URI	hdfsdfs -copyFromLocal input/docs/data2.txt hdfs://localhost/user/ rosemary/data2.txt
copyToLocal	Works similarly to the getcommand, except that the destination is restricted to a local file reference.	hdfsdfs -copyToLocal [-ignorecrc] [-crc] URI <localdst>	hdfsdfs -copyToLocal data2.txt data2.copy.txt
count	Counts the number of directories, files, and bytes under the paths that match the specified file pattern.	hdfsdfs -count [-q] <paths>	hdfsdfs -count hdfs://nn1.example.com/ file1 hdfs://nn2.example.com/ file2
cp	Copies one or more files from a specified source to a specified destination. If you specify multiple sources, the specified destination must be a directory.	hdfsdfs -cp URI [URI …] <dest>	hdfsdfs -cp /user/hadoop/file1 /user/hadoop/file2 /user/hadoop/dir
du	Displays the size of the specified file, or the sizes of files and directories that are contained in the specified directory. If you specify the-s option, displays an aggregate summary of file sizes rather than individual file sizes. If you specify the-h option, formats the file sizes in a "human-readable" way.	hdfsdfs -du [-s] [-h] URI [URI …]	hdfsdfs -du /user/hadoop/dir1 /user/hadoop/file1
dus	Displays a summary of file sizes; equivalent to hdfsdfs -du –s.	hdfsdfs -dus<args>
expunge	Empties the trash. When you delete a file, it isn’t removed immediately from HDFS, but is renamed to a file in the /trash directory. As long as the file remains there, you can undelete it if you change your mind, though only the latest copy of the deleted file can be restored.	hdfsdfs –expunge
get	Copies files to the local file system. Files that fail a cyclic redundancy check (CRC) can still be copied if you specify the -ignorecrc option. The CRC is a common technique for detecting data transmission errors. CRC checksum files have the .crc extension and are used to verify the data integrity of another file. These files are copied if you specify the -crcoption.	hdfsdfs -get [-ignorecrc] [-crc] <src><localdst>	hdfsdfs -get /user/hadoop/file3 localfile
getmerge	Concatenates the files insrc and writes the result to the specified local destination file. To add a newline character at the end of each file, specify theaddnl option.	hdfsdfs -getmerge<src><localdst> [addnl]	hdfsdfs -getmerge /user/hadoop/mydir/ ~/result_fileaddnl
ls	Returns statistics for the specified files or directories.	hdfsdfs -ls<args>	hdfsdfs -ls /user/hadoop/file1
lsr	Serves as the recursive version of ls; similar to the Unix command ls -R.	hdfsdfs -lsr<args>	hdfsdfs -lsr /user/ hadoop
mkdir	Creates directories on one or more specified paths. Its behavior is similar to the Unix mkdir -p command, which creates all directories that lead up to the specified directory if they don’t exist already.	hdfsdfs -mkdir<paths>	hdfsdfs -mkdir /user/hadoop/dir5/temp
moveFromLocal	Works similarly to the putcommand, except that the source is deleted after it is copied.	hdfsdfs -moveFromLocal<localsrc><dest>	hdfsdfs -moveFromLocal localfile1 localfile2 /user/hadoop/hadoopdir
mv	Moves one or more files from a specified source to a specified destination. If you specify multiple sources, the specified destination must be a directory. Moving files across file systems isn’t permitted.	hdfsdfs -mv URI [URI …] <dest>	hdfsdfs -mv /user/hadoop/file1 /user/hadoop/file2
put	Copies files from the local file system to the destination file system. This command can also read input from stdin and write to the destination file system.	hdfsdfs -put <localsrc> ... <dest>	hdfsdfs -put localfile1 localfile2 /user/hadoop/hadoopdir; hdfsdfs -put - /user/hadoop/hadoopdir (reads input from stdin)
rm	Deletes one or more specified files. This command doesn’t delete empty directories or files. To bypass the trash (if it’s enabled) and delete the specified files immediately, specify the -skipTrashoption.	hdfsdfs -rm [-skipTrash] URI [URI …]	hdfsdfs -rm hdfs://nn.example.com/ file9
rmr	Serves as the recursive version of –rm.	hdfsdfs -rmr [-skipTrash] URI [URI …]	hdfsdfs -rmr /user/hadoop/dir
setrep	Changes the replication factor for a specified file or directory. With -R, makes the change recursively by way of the directory structure.	hdfsdfs -setrep<rep> [-R] <path>	hdfsdfs -setrep 3 -R /user/hadoop/dir1
stat	Displays information about the specified path.	hdfsdfs -stat URI [URI …]	hdfsdfs -stat /user/hadoop/dir1
tail	Displays the last kilobyte of a specified file to stdout. The syntax supports the Unix -f option, which enables the specified file to be monitored. As new lines are added to the file by another process, tailupdates the display.	hdfsdfs -tail [-f] URI	hdfsdfs -tail /user/hadoop/dir1
test	Returns attributes of the specified file or directory. Specifies -e to determine whether the file or directory exists; -z to determine whether the file or directory is empty; and -d to determine whether the URI is a directory.	hdfsdfs -test -[ezd] URI	hdfsdfs -test /user/hadoop/dir1
text	Outputs a specified source file in text format. Valid input file formats are zipandTextRecordInputStream.	hdfsdfs -text <src>	hdfsdfs -text /user/hadoop/file8.zip
touchz	Creates a new, empty file of size 0 in the specified path.	hdfsdfs -touchz<path>	hdfsdfs -touchz /user/hadoop/file12