New features in Oracle Database 12c

New features in Oracle Database 12c

Size Limit on Varchar2, NVarchar2, Raw Data Types increased:

The previous limit on these data types was 4K. In 12C, it has been increased to 32,767 bytes. Upto 4K, the data is stored inline. I am sure everyone will be happy with this small and cute enhancement

 We can make a column invisible. 

SQL> create table test (column-name column-type invisible);
SQL> alter table table-name modify column-name invisible;
SQL> alter table table-name modify column-name visible;

Oracle Database 12c has new feature called "Identity Columns" 

which are auto-incremented at the time of insertion (like in MySQL).
SQL> create table dept (dept_id number generated as identity, dept_name varchar);
SQL> create table dept (dept_id number generated as identity (start with 1 increment by 1 cache 20 noorder), dept_name varchar);

 Temporary undo (for global temporary tables) will not generate undo. 

We can manage this by using init parameter temp_undo_enabled (=false|true).

Duplicate Indexes - Create duplicate indexes on the same set of columns. Till Oracle 11.2, if we try to create an index using the same columns, in the same order, as an existing index, we'll get an error. In some cases, we might want two different types of index on the same data (such as in a datawarehouse where we might want a bitmap index on the leading edge of a set of columns that exists in a Btree index).

PL/SQL inside SQL: this new feature allows to use DDL inside SQL statements (i.e.: to create a one shot function)

Pagination query:-

SQL keywords to limit the number of records to be displayed, and to replace ROWNUM records.
SQL> select ... fetch first n rows only;
SQL> select ... offset m rows fetch next n rows only;
SQL> select ... fetch first n percent rows only;
SQL> select ... fetch first n percent rows with ties;

select * from employees FETCH FIRST 2 PERCENT ROWS ONLY;

Moving and Renaming datafile is now ONLINE, no need to put data file in offline.
SQL> alter database move datafile 'path' to 'new_path';

The TRUNCATE command :-has been enhanced with a CASCADE option which follows child records.

Windows 10 Some tricks

Windows 10 Some tricks:-
----------------------------------

You can delete shorcut from below folder :-

%ProgramData%\Microsoft\Windows\Start Menu\Programs and
%AppData%\Microsoft\Windows\Start Menu\Programs 

Run the System File Checker tool (SFC.exe)

To do this, follow these steps:

1. Open an elevated command prompt. To do this, do the following as your appropriate:
   Windows 8.1 or Windows 8
   Swipe in from the right edge of the screen, and then tap Search. Or, if you are using a mouse, point to the lower-right corner of the screen, and then click Search. Type Command Prompt in the Search box, right-click Command Prompt, and then click Run as administrator. If you are prompted for an administrator password or for a confirmation, type the password, or click Allow.

         Windows 10, Windows 7, or Windows Vista

          To do this, click Start, type Command Prompt or cmd in the Search box, right-            click Command Prompt, and then click Run as administrator. If you are prompted for an administrator password or for a confirmation, type the password, or click Allow.

At the command prompt, type the following command, and then press ENTER:

sfc /scannow

After the process is finished, you may receive one of the following messages:

• Windows Resource Protection did not find any integrity violations.
  
  This means that you do not have any missing or corrupted system files.
• Windows Resource Protection could not perform the requested operation.
  
  To resolve this problem, perform the System File Checker scan in safe mode, and make sure that the PendingDeletes and PendingRenames folders exist under %WinDir%\WinSxS\Temp.
• Windows Resource Protection found corrupt files and successfully repaired them. Details are included in the CBS.Log %WinDir%\Logs\CBS\CBS.log.
  
  To view the detail information about the system file scan and restoration, go to How to view details of the System File Checker process.
• Windows Resource Protection found corrupt files but was unable to fix some of them. Details are included in the CBS.Log %WinDir%\Logs\CBS\CBS.log.
  
  To repair the corrupted files manually, view details of the System File Checker process to find the corrupted file, and then manually replace the corrupted file with a known good copy of the file.

Unix commands

Best site for Unix:-
http://www.grymoire.com/Unix/Sed.html

1) SED:
Sed Command :-
1) s for substitution:-
sed s/day/night/ new
echo day | sed s/day/night/
o/p=night

single quote
echo Sunday | sed 's/day/night/'

Another important concept is that sed is line oriented. Suppose you have the input file:

one two three, one two three
four three two one
one hundred

and you used the command

sed 's/one/ONE/'
The output would be

ONE two three, one two three
four three two ONE
ONE hundred


Note that this changed "one" to "ONE" once on each line. The first line had "one" twice, but only the first occurrence was changed. 
That is the default behavior. If you want something different, you will have to use some of the options that are available. I'll explain them later.
s  Substitute command
/../../  Delimiter
one  Regular Expression Pattern Search Pattern
ONE  Replacement string


2)The slash as a delimiter:-

The character after the s is the delimiter. It is conventionally a slash, because this is what ed, more, and vi use. It can be anything you want, however.
If you want to change a pathname that contains a slash - say /usr/local/bin to /common/bin - you could use the backslash to quote the slash:


sed 's/\/usr\/local\/bin/\/common\/bin/' new

Gulp. Some call this a 'Picket Fence' and it's ugly. It is easier to read if you use an underline instead of a slash as a delimiter:

sed 's_/usr/local/bin_/common/bin_' new
Some people use colons:

sed 's:/usr/local/bin:/common/bin:' new
Others use the "|" character.

sed 's|/usr/local/bin|/common/bin|' new

3)Using & as the matched string:-

Sometimes you want to search for a pattern and add some characters, like parenthesis, around or near the pattern you found. It is easy to do this if you are looking
for a particular string:

sed 's/abc/(abc)/' new

This won't work if you don't know exactly what you will find. How can you put the string you found in the replacement string if you don't know what it is?

The solution requires the special character "&." It corresponds to the pattern found.

sed 's/[a-z]*/(&)/' new

4:-Using \1 to keep part of the pattern:-

The "\1" is the first remembered pattern, and the "\2" is the second remembered pattern. Sed has up to nine remembered patterns.

If you wanted to keep the first word of a line, and delete the rest of the line, mark the important part with the parenthesis:

sed 's/\([a-z]*\).*/\1/'

echo abcd123 | sed 's/\([a-z]*\).*/\1/'

This will output "abcd" and delete the numbers.

If you want to switch two words around, you can remember two patterns and change the order around:

sed 's/\([a-z]*\) \([a-z]*\)/\2 \1/'
If you want to detect duplicated words, you can use

sed -n '/\([a-z][a-z]*\) \1/p'

5:-/g - Global replacement:-

Most UNIX utilities work on files, reading a line at a time. Sed, by default, is the same way. If you tell it to change a word, it will only change the first
occurrence of the word on a line. You may want to make the change on every word on the line instead of the first. For an example, 
let's place parentheses around words on a line. Instead of using a pattern like "[A-Za-z]*" which won't match words like "won't," 
we will use a pattern, "[^ ]*," that matches everything except a space. Well, this will also match anything because "*" means zero or more.
The current version of Solaris's sed (as I wrote this) can get unhappy with patterns like this, and generate errors like "Output line too long" or even run forever. 
I consider this a bug, and have reported this to Sun. As a work-around, you must avoid matching the null string when using the "g" flag to sed.
A work-around example is: "[^ ][^ ]*." The following will put parenthesis around the first word:

sed 's/[^ ]*/(&)/' new
If you want it to make changes for every word, add a "g" after the last delimiter and use the work-around:

sed 's/[^ ][^ ]*/(&)/g' new


6:-/p - print:-

By default, sed prints every line. If it makes a substitution, the new text is printed instead of the old one. If you use an optional argument to sed,
"sed -n," it will not, by default, print any new lines. I'll cover this and other options later. When the "-n" option is used, the "p" flag will cause 
the modified line to be printed. Here is one way to duplicate the function of grep with sed:

sed -n 's/pattern/&/p'

Production support means

Production support means, whenever a problem/Error rises while the product is
running we have to identify that problem/Error and solve it, or intimate about
that problem/Error to the concern person, who is responsible for that
problem/Error.

Informatica production support means, we have to watch the workflow monitor
carefully, is all workflows and all Tasks are running properly or not. (Means
data is loading in the proper way and to the right targets, and at the right
time, or not).

If any problem/Error rises:
1) We have to resolve it, and restart/recover that certain workflow and task.
(If that error reservation responsibility is only ours).
2) Intimate about that error to the concern person, which is responsible for
that error. (If that error cont solved by us).

Here problem/Error means - workflows and tasks are not running or, they are
not started at the scheduled times or, some problems occurred at the data
loading, or any server is down << Informatica server>> << Repository server>> 

1) Have to monitor the scheduled jobs or run the workflows and scripts which needs to run the day.
2) If any issues or job fails, Immediately check the logs and contact with support team if needed. Frequently have to intimate all responding peoples.
3) Maintain the root cause analysis & issues tracker sheet
4) Have to provide the value added points and try to improve the current process much better.
6) Maintain a log files, screenshot, run statistics

Event Wait ask in informaica

Event Wait  ask in informaica

http://kumarmayank-ideasandviews.blogspot.in/2014/07/v-behaviorurldefaultvmlo.html


http://etl-developer.com/2011/01/work-flow-dependency-in-informatica-event-wait-files/

OBIEE 12c and ORACLE 12c installation steps and related web links

ORACLE 12c installation steps

Oracle 12c :-s

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/Windows_DB_Install_OBE/Installing_Oracle_Db12c_Windows.html

https://nehakohlidba.wordpress.com/2016/01/26/oracle-12c-installation-on-windows-64bit-in-as-simple-as-12-steps/

I faced below issue while installation :-

https://nehakohlidba.wordpress.com/2016/01/26/updating-registry-key-hkey_local_machinesoftwareoraclekey_oradb12home1/

https://nehakohlidba.wordpress.com/2016/01/26/oracle-12-installation-stuck-at-88-at-oracle-database-configuration-assistant/

How to unlock HR user in oracle 12c :-

http://www.rebellionrider.com/oracle-database-12c-tutorial/how-to-unlock-hr-user-in-oracle-database-12c.htm#.V8LHOyh97IU

You can delete shorcut from below folder :-

%ProgramData%\Microsoft\ Windows\Start Menu\Programs and

%AppData%\Microsoft\Windows\Start Menu\Programs

OBIEE 12c installation steps

Below link is useful to obiee12 c installation ;-

http://ssssupport.blogspot.in/2015/10/installing-oracle-obiee-12c-in-windows.html

http://allthingsorcl.blogspot.in/2015/10/obiee-12c-installation-steps.html

OBIEE 12C CLIENT INSTALLATION

http://ssssupport.blogspot.in/2015/11/obiee-12c-client-installation.html

In Installation time if u get error same like this

OBIEE 12C INSTALLER ARCHIVE CORRUPTION ERROR 

then  use below link..

http://www.redstk.com/obiee-12c-installer-archive-corruption-error/

OBIEE 12C New Features

http://ssssupport.blogspot.in/2015/11/obiee-12c-ui-new-features_70.html

OBIEE12c Upload and download command:-

http://nagabi.blogspot.co.uk/2015/11/obiee-12c-rpd-upload-and-download.html

OBIEE12 : how to start and stop BI services

http://deliverbi.blogspot.in/2015/10/obiee-12c-start-and-stop-scripts-no.html

https://medium.com/red-pill-analytics/obiee-12c-where-it-all-went-2f1cf7cacfb#.eeucn4lbf

log Files location in OBIEE 12c

http://aditya-kaushal.blogspot.in/2015/11/log-files-location-in-obiee-12c.html

Thanks :)

I found one blog for PDM round...:)

I found one blog for PDM round...:)

http://www.pdmconsultancy.com/candidate-career-centre/43-how-to-answer-the-5-most-typical-telephone-interview-questions


If any have best suggestion for about PDM question and how to tackle the situation then please
comment on below....

Unix Important command which will Defiantly help you .....:)

Unix Important command which will Defiantly help you .....:)


Give the Numbring in VI:
:se nu

How to find duplicate:-
/name

vi Find And Replace Text Command

:%s/FindMe/ReplaceME/g

 Find and Replace with Confirmation

:%s/UNIX/Linux/gc

Find and Replace Whole Word Only

:%s/\/Linux/gc

Case Insensitive Find and Replace

:%s/unix/Linux/gi

How Do I Replace In the Current Line Only?

:s/UNIX/Linux/g

How Do I Replace All Lines Between line 100 and line 250?

:100,200s/UNIX/Linux/gc

Some Vi Control :-

0 or | Positions cursor at beginning of line.

$ Positions cursor at end of line.

w Positions cursor to the next word.

b Positions cursor to previous word.

( Positions cursor to beginning of current sentence.

) Positions cursor to beginning of next sentence.

E Move to the end of Blank delimited word

{ Move a paragraph back

} Move a paragraph forward

[[ Move a section back

]] Move a section forward

n| Moves to the column n in the current line

1G Move to the first line of the file

G Move to the last line of the file

nG Move to nth line of the file

:n Move to nth line of the file

fc Move forward to c

Fc Move back to c

H Move to top of screen

nH Moves to nth line from the top of the screen

M Move to middle of screen

L Move to botton of screen

nL Moves to nth line from the bottom of the screen

:x Colon followed by a 

The basic syntax of AWK:

awk 'BEGIN {start_action} {action} END {stop_action}' filename

 awk '{print $1}' input_file

Here $1 has a meaning. $1, $2, $3... represents the first, second, third columns... in a row respectively.

1. Cursor Navigation (if your arrow keys dont work on that old Sun box....)
J	Next line
K	Previous line
H	Left
L	Right
Shift+G	Bottom of document
GG	Top of document

▲ up

2. Fast Search
/	Search Term
N	Next
N	Previous

▲ up

3. Command Mode
:	enter command mode
:w	write
:q	quit
:q!	quit without saving
:wq	Write and quit
ZZ	Write and quit
:e	open
Esc	escape command mode

▲ up

4. From Normal to Edit Mode
I	Insert at current position
I	Insert at start of line
A	Append to end of line
O	Insert Line Below
O	Insert Line Above
S	Delete character at current position and insert
S	Delete the current line and insert

▲ up

5. Clipboard
dw	delete word
dd	delete line
P	put after cursor
P	put before cursor
yw	copy word
yy	copy line