HASIM`S_ABODE

Desi Bhai ( Brother from my Country)....!!!

2010-10-27T21:49:00.000+05:30

Desi bhai (BanglaDESI Brother). I looked back over my shoulders hearing that in bengali. It was a bangla speaking, mid 40 guy with a shabby looks.

I was in Changi Airport to receive my lecturer.
"Do you have some loose coins, I need to call my agent here"
I did not have loose coins, so I let him use my cell. He took out some half torned paper where he has the number and started calling. I went a bit further to allow privacy.

"Ki boltase bujhtasi na. Apni dahen akbar(Dont know what is he saying.You please try once)" - he said with desparation.Somebody rightly said that in anger, love or emotion people starts talking their own language or in proper tone. I could clearly felt that this guy is from Shillete of Bangladesh (A state of Bangladesh)

I tried to call the number and heard that somebody is talking in chineese on other side.Clearly some wrong number.
-"You might have noted some wrong number".I told the guy.

-"Aita kothai hobe, ektu bolte paren ( Can you tell, where will be the place)"?. He again took out some oily paper with an address nearby to Kranji. Might be some dormitory.

I felt annoyed.What a pain? Anybody can recognise me as a Bengali from my looks..!! I cursed my looks.
I can see that my lecturer is also coming. I directed him towards the taxi que and asked him to show the paper to the driver.

Me and my lecturer was about board the cab.Suddenly the fellow come from backside."Brother, you gave me your cell to use".He is holding a 10 SGD note in his hand.
-"No, no its okay. And after all the calls do not cost 10 $ at all.Keep it"

Now my lecturer suddenly became enthuastic hearing somebody from his place and talking in his mother-tounge....!! I hold my head. I know when two first comers meet in a foreign place what happens.

Well,their long discussions ended after a gracious lunch offered my lecturer. I knew that the bengali guy has got a lucrative offer to work as a plumber with basic salary as 700 SGD with extra overtime...!! He is very excited that he can do so much overtime and send quite a lot of money back to his home where he left his wife and two kids.

I almost forgot that incident until I felt the need to adjust the height of my ceiling fan. I called the electrician.I became amazed seeing my friend once again.
-"Bhaijan chinte paren? Kemon asen?( Brother, can you remember me? How are you?"

-"yes, of course. What a surprise!! You as a electrician!! As I remember you came as a plumber,right?"

-"Yes, nowdays not so much work of plumber.I saved some money and that finished in that bad time. And I changed agent once again and this time made my job as a electrician. In this atleast I will have some work from time to time."

"Why dont you go back?" - I asked when I knew that whenever he changes a agent he need to pay around 2000 $. "After all in this way you can not save money. And Singapore job market is not good. And dont mind, dont you think that you can not earn 700 $ in your country?"

Many foreign workers come here with the dream that they can earn a lot. And for that they sell their lands, mortgage their house to collect money for the agent. And they understand the reality just after reaching here. They wish so much to go back but they can not accept the fact that they will go back with empty hand whereas they have their house morgaged, their land also gone.They continue more time in dormitory which is over-packed by some more dreamers.They got work sometime and sometime just do any odd works like packing-unpacking goods in supermarket. People hate them, nobody wants to sit beside them in MRT or buses. Ladies avoid them as they used to glare them.

The other weekend I was helping my Malay friend to shift his house and oh my....The same bengali guy is here with a gang. He saw me and friends.
-"Apanar malay dost o ase naki?(you have malay friends too?)"- He asked jokingly while moving the refrigerator inside the kitchen.I knew from him that now he is doing this 'movers-job' as a part-time hiring the truck from his boss.

-"Do you have driving licence to drive?"- I asked.
-" Apni ki bhaben je apnar sudhu malay dost ase?( Don you think you only have malay friends"). He replied with loud bang on his chinese friend back - "Lim is our driver". Poor Lim did not understand why he got such a bang. BUt I understood that my friend is quite popular among his friends.

He will never take the mover's charge when he knew that the guy is my friend. "You gave me a lot of extra when I went to repair your ceiling fan. And yours friend is my friend too"- He insistingly said. I signalled my friend that no benifit of forcing to give them money. So we offered then a good dinner donwstairs.

It is really strange that a person can laugh so heartily without any tension when he is earning from hand-to-mouth. It is stranger to show such a gratefulness to some stranger who is incidentally his friend's friend. And who is his friend?- Who helped him by lettling him call two time to some local number!!

I did not see that guy after that.
Neither I saw him in the crouds in front of Mustafa(24 hours popular store in Singapore) who are buying some mobile burgain and getting one free goodie bag nor in the small mini-vans carrying the exacly same tired looking workers who are dozzing in slumber to their dormitory.

Nowdays if I saw that some "Desi Bhai" sitting alone in a jampacked bus,I accompany him. After all I can not change my looks and in emotion I also speak up in bengali. Let others think whatever they want.

Another recession.....!!!

2010-10-25T02:11:00.000+05:30

Nowadays there is a hue and cry on recession.

In my dictionary it is a new word. I never heard about it couple of months before. And then suddenly I became so aware about it and its scary wrinkled face. Now I think I can claim expertise on this as I know why US goes into recession, why there is only 5% property booked in Burj-Al-Khalifa, why Germans are shouting when their government bails out the sinking Greece,why the European banks are kneeling,will it be Icelands turn now etc etc. I can also put worthy comment on property Bubble burst and believe me its scary; not at all like childhood colorful soap bubble burst. I know that we can pump water into a tub I never heard that money can also be pumped into economy and that also pump,pump and pump to a leaky bucket. Cool new learning for me indeed.

I silently praise the warriors who pacifies me saying "Dont worry...Things will be okay...I have seen how many IT guys loose jobs on DOT.COM burst". Man, seems this burst is more scarier than the tyre bursts in US Highway 50 or the hill-way towards Ladakh with no spare tyre..!! I like those warriors face expression when they take so pleasure to relate various stories related to the DOT.COM burst time. Sometimes I think IT guys love to get worried and tensed. But thinking and real life scenario might be different, so I follow the experts advice - "Sit tight wherever you are...keep ticking 12 hours without and chaos in office and if needed buy some Fevicol to apply on your office chair". As I told, I admire my warriors and thus I follow their golden suggestions. After all I am new in recession.

But I think, some other form of recessions starts longgg....long before the 'US/Dubai property market' or 'European banks' or 'Greece economy' fails.That is recession in humanity.
In public transport while getting in we elbow some spectacled aged guy to grab a seat meant for elders or more needy person and pretend to sleep. We rush while driving cutting in and out of lane. That's different matter that whom I overtook sometimes stops next to my lane at a RED light. We shamelessly show some other persons work as mine in office to please my blind boss and take a nap after lunch when working-from-home keeping the messenger status as 'VERY BUSY'. We don't care the stupid pedestrians at ZEBRA crossing and why should we when we are riding in BMW and he is crossing the road with a shabby bag full of vegetables. We don't bother if you catch us kissing at the back alley and why should we when you might also did the same when you were young. We are quick to press the lift button if we see others are coming, after all it is kinda subtle pride we feel that we will reach my floor faster than you. We don't care any more to know why my next-door neighbours son crying or why the ambulance came late night to our small society. In fact there if no point of knowing when we barely know any of my neighbours. What we know nowadays is only the "I and we" and yes of course the "You" provided that "You" is either my girlfriend or my BOSS.

Clearly the other form of recession started long before but till now I didn't find any warriors whom I can praise or any government who can pump,pump and pump humanity.

I am still searching and I doubt I will find ever as I know the numbers of the warriors are very less and the hole in the leaky bucket is pretty big.

Notes on Uniqueness....!!

2010-10-24T19:36:00.000+05:30

Whether it is a people or a race or a country, we should never forget our uniqueness, cultures and roots.

You may feel that she looks stunning in the high colar black jacket but you never realized that others like your simplicity; your's simple looks.You starts mimicking the american tone while speaking and while humming a Lady Gaga song you pick wrong notes but you never realized when you chants the ghazal, you mesmerise the passers-by. You thought to get success in business by copying some well known and popular product to realize later that your business is far behind to the business you copied.And the reason is that he has started long before you started and he knew that someday somebody wil copy him and then how can he come out with better product. Everybody in this world is unique. You better goom and nurture those unique qualities for a better acceptance

In South east asia and middle east there is a surge of Bollywood movies. The same bollywood movies which used to be called as dumb dancing-around-the-tree movies by the west. There is an increase influx of western actors in bollywood movies too.The reason is bollywood has a huge market outside India. It is good to see that Bollywood retains its flavor blodly stating that "love it or hate it, this is it"; and yes its presence is increasing in multifold than earlier. In many countries you can easily hear a popular bollywood song and in big cities you can find a "Bollywood Dance" class.Earlier time kathakali is coined as a ghost-dance for its unique appearance of the dancers and rapid eye movement and now it is a world known dance.Similarly when somebody talks about Bihu you propmtly asks him back -are you from Assam? With nominal dance steps and stereotype tune bhangra is another name for Punjab.Abroad while in Chinese new year, the cebration is incomplete without dragon dance; Deepavali is incomplete without lamps and colurs;halloween is incomplete without weird,fearful attrires.I believe there is not a single big city in this world where you will not be able to find an Indian Restaurant. And they are successfull too just by showcasing their countries delicacies.At the same time I wonder how many Indians became successfull opening up an western food giant!! It is all about the roots or the cultures of the country or states when it it comes about identity. You forget it, others forget you.

I am not so blunt to say that mimicing is wrong. Following others might be good sometimes but never always. If you can adopt good things from others keeping your own stucture intact, it is good. Any revolutionary product, the nobel prize always followed by a great idea or unique idea which is original.

After all - “Today you are You, that is truer than true. There is no one alive who is Youer than You.”

HowToOracle:- Everything about exceptions

2010-08-19T16:31:00.004+05:30

Every thing about Oracle Exception Handling
================================================
Facts:-
1. There are 2 kinds of exceptions:-
System defined / pre-defined exceptions
Programmer-Defined Exceptions

2. System defined exceptions are exceptions that have been given names by PL/SQL. They are named in the STANDARD package in PL/SQL and do not need to be defined by the programmer.

Oracle has a standard set of exceptions already named as follows:

Oracle Exception Name
Oracle Error
Explanation

DUP_VAL_ON_INDEX
ORA-00001
You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index.

TIMEOUT_ON_RESOURCE
ORA-00051
You were waiting for a resource and you timed out.

TRANSACTION_BACKED_OUT
ORA-00061
The remote portion of a transaction has rolled back.

INVALID_CURSOR
ORA-01001
You tried to reference a cursor that does not yet exist. This may have happened because you've executed a FETCH cursor or CLOSE cursor before OPENing the cursor.

NOT_LOGGED_ON
ORA-01012
You tried to execute a call to Oracle before logging in.

LOGIN_DENIED
ORA-01017
You tried to log into Oracle with an invalid username/password combination.

NO_DATA_FOUND
ORA-01403
You tried one of the following:
You executed a SELECT INTO statement and no rows were returned.
You referenced an uninitialized row in a table.
You read past the end of file with the UTL_FILE package.

TOO_MANY_ROWS
ORA-01422
You tried to execute a SELECT INTO statement and more than one row was returned.

ZERO_DIVIDE
ORA-01476
You tried to divide a number by zero.

INVALID_NUMBER
ORA-01722
You tried to execute an SQL statement that tried to convert a string to a number, but it was unsuccessful.

STORAGE_ERROR
ORA-06500
You ran out of memory or memory was corrupted.

PROGRAM_ERROR
ORA-06501
This is a generic "Contact Oracle support" message because an internal problem was encountered.

VALUE_ERROR
ORA-06502
You tried to perform an operation and there was a error on a conversion, truncation, or invalid constraining of numeric or character data.

CURSOR_ALREADY_OPEN
ORA-06511
You tried to open a cursor that is already open.

Sample Procedure describing handling NO_DATA_FOUND error:-
---------------------------------------------------------------
CREATE OR REPLACE PROCEDURE proc_named_exception
AS
v_ename emp.ename%TYPE;
BEGIN
SELECT ename INTO v_ename FROM emp WHERE ename = 'SMITH';
Dbms_Output.put_line('Employe name is = '||v_ename); -- Valid record willbe shown in output
/* the following will throw NO_DATA_FOUND exception */
SELECT ename INTO v_ename FROM emp WHERE ename = 'TITIKAKA';
Dbms_Output.put_line('Employe name is = '||v_ename); -- NO_DATA_FOUND, so control will go to exception block
-- Nothing will be shown in output
SELECT ename INTO v_ename FROM emp WHERE ename = 'KING';
Dbms_Output.put_line('Employe name is = '||v_ename);
EXCEPTION
WHEN No_Data_Found THEN
Dbms_Output.put_line('no data found');
END;

Facts 3:- By default, you put an exception handler at the end of a subprogram to handle exceptions that are raised anywhere inside the subprogram. To continue executing from the spot where an exception happens, enclose the code that might raise an exception inside another BEGIN-END block with its own exception handler. For example, you might put separate BEGIN-END blocks around groups of SQL statements that might raise NO_DATA_FOUND, or around arithmetic operations that might raise DIVIDE_BY_ZERO. By putting a BEGIN-END block with an exception handler inside a loop, you can continue executing the loop even if
some loop iterations raise exceptions.See sample 2 below.

Sample 2 Procedure describing handling NO_DATA_FOUND and DUP_VAL_ON_INDEX error:-
-------------------------------------------------------------------------------
CREATE OR REPLACE PROCEDURE proc_named_exception1
AS
v_ename emp.ename%TYPE;
BEGIN
BEGIN -- This block is to handle NDF
SELECT ename INTO v_ename FROM emp WHERE ename = 'SMITH';
Dbms_Output.put_line('Employe name is = '||v_ename); -- Valid record willbe shown in output
/* the following will throw NO_DATA_FOUND exception */
SELECT ename INTO v_ename FROM emp WHERE ename = 'TITIKAKA';
Dbms_Output.put_line('Employe name is = '||v_ename); -- NO_DATA_FOUND, so control will go to exception block
-- Nothing will be shown in output
SELECT ename INTO v_ename FROM emp WHERE ename = 'KING';
Dbms_Output.put_line('Employe name is = '||v_ename);
EXCEPTION
WHEN No_Data_Found THEN
Dbms_Output.put_line('NO_DATA_FOUND');
END;

BEGIN -- This block is to handle DVOI
INSERT INTO emp VALUES(7369,'Hasim','Admin',9898,SYSDATE,7000,NULL,10);
COMMIT;
EXCEPTION
WHEN DUP_VAL_ON_INDEX THEN
Dbms_Output.put_line('DUP_VAL_ON_INDEX');
END;
END;

Fact 4:- You can handle more than one exception in a single handler as follows:-

EXCEPTION
When NO_DATA_FOUND or TOO_MANY_ROWS then
Statements;
END;

Fact 5:- A User-defined exception has to be defined by the programmer. User-defined exceptions are declared in the declaration section with their type as

exception.They must be raised explicitly using RAISE statement, unlike pre-defined exceptions that are raised implicitly. RAISE statement can also be used to

raise internal exceptions.

Declaring Exception:
--------------------

DECLARE
myexception EXCEPTION;
BEGIN

Raising Exception:
------------------
BEGIN
RAISE myexception;

Handling Exception:
----------------------
BEGIN
EXCEPTION
WHEN myexception THEN
Statements;
END;

Sample 3 Procedure addemp in the package is having an user defined exception
-------------------------------------------------------------------------------

PROMPT CREATE OR REPLACE PACKAGE hasim_pack2
CREATE OR REPLACE PACKAGE hasim_pack2 AS
PROCEDURE addemp;
PROCEDURE delemp;
END hasim_pack2;
/

PROMPT CREATE OR REPLACE PACKAGE BODY hasim_pack2
CREATE OR REPLACE PACKAGE BODY hasim_pack2 AS
PROCEDURE addemp IS
is_exists EXCEPTION;
cnt NUMBER :=0;
BEGIN
SELECT Count(1) INTO cnt FROM emp WHERE empno IN (9898,9897);
IF cnt > 0 THEN
RAISE is_exists;
else
INSERT ALL
INTO emp VALUES(9898,'Timothy','CEO',7839,SYSDATE,7000,NULL,10)
INTO emp VALUES(9897,'Hasim','Admin',9898,SYSDATE,7000,NULL,10)
SELECT * FROM dual;
COMMIT;
END IF;
EXCEPTION
WHEN is_exists THEN
Raise_Application_Error(-20001,'You must delete Timothy/hasim first');
WHEN OTHERS then
Raise_Application_Error(-20002,'Some error happened while inserting records');
END addemp;

PROCEDURE delemp IS
begin
DELETE FROM emp WHERE empno IN (9898,9897);
COMMIT;
END delemp;

END hasim_pack2;
/

Fact 6:-
An Exception cannot be declared twice in the same block.
Exceptions declared in a block are considered as local to that block and global to its sub-blocks.An enclosing block cannot access Exceptions declared in its sub-block. Where as it possible for a sub-block to refer its enclosing Exceptions.

Sample 4 Exceptions raised in sub-block is handled by main block
-----------------------------------------------------------------
CREATE OR REPLACE PROCEDURE proc_named_exception3
AS
v_ename emp.ename%TYPE;
res NUMBER;
BEGIN
BEGIN -- This block is to handle TMR
SELECT ename INTO v_ename FROM emp WHERE job = 'PRESIDENT';
Dbms_Output.put_line('President Employe name is = '||v_ename); -- Valid record willbe shown in output
SELECT (10/2) INTO res FROM dual;
Dbms_Output.put_line('10/2 = '||res); -- Valid record willbe shown in output
SELECT (10/0) INTO res FROM dual;
Dbms_Output.put_line('10/0 = '||res); -- Zero_Divide,no record willbe shown in output,exception catcher is in main block
EXCEPTION
WHEN TOO_MANY_ROWS THEN
Dbms_Output.put_line('TOO_MANY_ROWS');
END;

BEGIN -- This block is to handle DVOI
INSERT INTO emp VALUES(7369,'Hasim','Admin',9898,SYSDATE,7000,NULL,10);
COMMIT;
EXCEPTION
WHEN DUP_VAL_ON_INDEX THEN
Dbms_Output.put_line('DUP_VAL_ON_INDEX');
END;
EXCEPTION
WHEN Zero_Divide THEN
Dbms_Output.put_line('Zero_Divide');
END;

Fact 7:- RAISE_APPLICATION_ERROR
To display your own error messages one can use the built-in RAISE_APPLICATION_ERROR. They display the error message in the same way as Oracle errors. You should use a negative number between –20000 to –20999 for the error_number and the error message should not exceed 512 characters. Check sample 3.

Fact 8:- The WHEN OTHERS clause is used to trap all remaining exceptions that have not been handled by the System defined Exceptions and Programmer-Defined Exceptions.

Sample 5 Usage of when others in the previous addemp procedure
----------------------------------------------------------------
create or replace PROCEDURE addemp1 IS
is_exists EXCEPTION;
cnt NUMBER :=0;
BEGIN
SELECT Count(1) INTO cnt FROM emp WHERE empno IN (9898,9897);
IF cnt > 0 THEN
RAISE is_exists;
else
INSERT ALL
INTO emp VALUES(9898,'Timothy','CEO',7839,SYSDATE,7000,NULL,10)
INTO emp VALUES(9897,'Hasim','Admin',9898,SYSDATE,7000,NULL,10)
SELECT * FROM dual;
COMMIT;
END IF;
SELECT (10/0) INTO cnt FROM dual;
EXCEPTION
WHEN is_exists THEN
Raise_Application_Error(-20001,'You must delete Timothy/hasim first');
WHEN OTHERS then
Raise_Application_Error(-20002,'Some error happened while inserting records');
END addemp1;

SQL> exec addemp1;
BEGIN addemp1; END;

*
ERROR at line 1:
ORA-20001: You must delete Timothy/hasim first
ORA-06512: at "SCOTT.ADDEMP1", line 17
ORA-06512: at line 1

SQL> exec hasim_pack2.delemp;

PL/SQL procedure successfully completed.

SQL> exec addemp1;
BEGIN addemp1; END;

*
ERROR at line 1:
ORA-20002: Some error happened while inserting records
ORA-06512: at "SCOTT.ADDEMP1", line 20
ORA-06512: at line 1

SQL>

Fact 9:- The SQLCODE function returns the error number associated with the most recently raised error exception. This function should only be used within the Exception Handling section of your code.

Sample 5 Usage of when others in the previous addemp procedure
----------------------------------------------------------------
create or replace PROCEDURE addemp2 IS
is_exists EXCEPTION;
cnt NUMBER :=0;
BEGIN
SELECT Count(1) INTO cnt FROM emp WHERE empno IN (9898,9897);
IF cnt > 0 THEN
RAISE is_exists;
else
INSERT ALL
INTO emp VALUES(9898,'Timothy','CEO',7839,SYSDATE,7000,NULL,10)
INTO emp VALUES(9897,'Hasim','Admin',9898,SYSDATE,7000,NULL,10)
SELECT * FROM dual;
COMMIT;
END IF;
SELECT (10/0) INTO cnt FROM dual;
EXCEPTION
WHEN is_exists THEN
Raise_Application_Error(-20001,'You must delete Timothy/hasim first');
WHEN OTHERS then
Raise_Application_Error(-20002,'Some error happened while inserting records'||SQLCODE||' -ERROR- '||SQLERRM);
END addemp2;

Samplerun:-
SQL> exec hasim_pack2.delemp;

PL/SQL procedure successfully completed.

SQL> exec addemp2;
BEGIN addemp2; END;

*
ERROR at line 1:
ORA-20002: Some error happened while inserting records-1476 -ERROR- ORA-01476:
divisor is equal to zero
ORA-06512: at "SCOTT.ADDEMP2", line 20
ORA-06512: at line 1

HowToTeraData: Beginners guide to teradata.

2010-08-18T22:30:00.006+05:30

1. Getting the software and installing it:-
Get the demo version from http://www.teradata.com/dwdemo

2. Logon using BTEQ

From command mode run bteq or bteqwin( for windows version).

default userid is /dbc
default password is dbc

C:\Documents and Settings\Hasim>bteq

Teradata BTEQ 13.00.00.03 for WIN32.
Copyright 1984-2009, Teradata Corporation. ALL RIGHTS RESERVED.
Enter your logon or BTEQ command:
.logon

.logon
UserId: dbc
Password:

*** Logon successfully completed.
*** Teradata Database Release is 13.00.00.12
*** Teradata Database Version is 13.00.00.12
*** Transaction Semantics are BTET.
*** Character Set Name is 'ASCII'.

*** Total elapsed time was 2 seconds.

BTEQ -- Enter your DBC/SQL request or BTEQ command:

If facing the following error then Check HowToTeraData: CLI error: MTDP: EM_NOHOST(224): name not in HOSTS file or names database

3. Create user/database
---- Need to see -----
create user hasim_tdt from dbc as
permanent = 1000000
,password = hasim_tdt
,spool = 2000000
,fallback protection
,dual after journal
,default journal table = hasim_tdt.journals
,account = '$dbc';

4. what are the tables in DBC?

--- NTS ----

5. How to interrupt execution in bteqwin/bteq if something wrong happens?

--- NTS ---

HowToTeraData: CLI error: MTDP: EM_NOHOST(224): name not in HOSTS file or names database.

2010-08-18T21:51:00.004+05:30

CLI error: MTDP: EM_NOHOST(224): name not in HOSTS file or names database.

Solution:-
Edit the file C:/WINDOWS/SYSTEM32/DRIVERS/ETC/HOSTS
Edit the following line as:-

127.0.0.1 localhost dbccop1

Close Bteq/Bteqwin and retry.

** How will you know it should be dbccop1 ?
In the tdpid,after cop it should be 1 as you are using on a local machine and there is only one RDBMS and before cop it should be dbc as you can verify your i_dbcpath variable value from C:\Program Files\Teradata\Client\13.0\CLIv2\clispb.dat.

Informatica 8.6.0:Installing Powercenter in Windows XP Oracle 10g

2010-08-14T03:47:00.004+05:30

Informatica 8.6.0: Installation Steps in WINDOWS XP ( Service Pack 2) Oracle 10g
/************************************************
* INFORMATICA 8.6.0 Installation Steps
* OS: WINXP(SP-2)
* Oracle 10g
*************************************************/

1. Create an user for informatica metadata:-
DROP user utopia_user cascade;
CREATE USER utopia_user IDENTIFIED BY utopia_user DEFAULT TABLESPACE users QUOTA UNLIMITED ON users;
GRANT CONNECT,DBA TO utopia_user;

2. Installation Type
New installation.

3. Licence Key
Provide the path of the licence key.

4. Installation Directory
Provide the path.

5. HTTPS configuration
Keep default.

6. Domain configuration
New domain. While configuring domain database provide the database and the the database user info which you have created in step 1.

7. Creating domain
Accept the default name.Provide the domain name itself as domain password for easy remembering.

8. Informatica Service configuration.
Username: machinename\username
Password:

Troubleshooting
What is the powercenter administration console username/password?
>> admin/
OR
Administrator/Administrator

Q&A

2010-06-22T11:40:00.001+05:30

From: pragnya paramita
Subject: Hi
To: m_a_hasim@yahoo.com
Date: Friday, June 11, 2010, 8:54 AM

Hi, haseem
m pragnya
i hv a qs plz clarrify it
how to start and stop all of our workflow through unix shell script.

Thanks,
prganya

pmcmd -startworkflow
pmcmd -stopworkflow

Check the details on pmcmd.

~Hasim
----------------------------------------------------

From: pragnya paramita
To: Abul Hasim Molla
Sent: Mon, June 14, 2010 12:42:44 PM
Subject: Re: Hi

hi hasim
thanx 4 u r reply
i hv sm more qs

1.how can we join 2 flat files with diff structure without using joiner,updtstgy
There are couple of unix commands there to do this.
2.i know we can use sorrogate key in scd type 1 but can u tell me in which scenario we can use
In most of the cases we use it when we want something unique key in our own datawarehouse.
3.from previous qs i know through pmcmd command we can start workflow and stop it also but i want throuh script program. so plz can u send me any shell script where its written start workflow and stop wrkflow.
Check my blog. You will see some pratical unix shell script on that.

Thanks,
pragnya

-------------------------------------------------------------
> ________________________________
>
> From: Nitant_Mahajan
> Sent: Thursday, August 03, 2006 7:49 PM
> To: m_a_hasim@yahoo.com
> Subject: HELP_REQUIRED-36401
>
>
> HELLO SIR ,
> IM FACING ONE PROBLEM IN INFORMATICA(36401),
BECAUSE OF WHICH OUR
> DELIVERY IS GETTING DELAYED.
> WE FOUND YOUR ARTICLE ON NET AND WAS WONDERING IF
YOU CAN HELP ME OUT.
> DO YOU HAVE DETAILED DESCRIPTION ABOUT THIS PROBLEM.
>
> WOULD BE GRATEFUL IF YOU CAN PROVIDE ME YOUR CONTACT
NO SO THAT I CAN
> EXPLAIN YOPU THE SCENARIO.
>
>
> RGDS
> NITANT

> hello sir,
> that problem is resolved now. actually wht
happened was that we were
> calling certain batch files through informatica,as a
result an Cmd.exe
> process was run in the background. this batch file
was calling another
> batch file,so after one run of workflow, when the
control returned to
> command prompt there was still one cmd.exe opened.
this was increasing
> by one evereytime when we run the workflow in the
loop.Each cmd process
> was talking more than 4 mb space. so when we were
running the workflow
> in the loop for more than 20-30 times this problem
was coming.
>
> hope to disturb in future sometime.
>
>
> rgds
> nitant
-------------------------------------------------------------

HASIM`S_ABODE: HowToEpiphany: Installing SSA Outbound Marketing In Windows

2010-06-01T14:39:00.000+05:30

HASIM`S_ABODE: HowToEpiphany: Installing SSA Outbound Marketing In Windows

UnixHowTo: Stopped (tty output) HP Unix

2010-01-12T12:06:00.004+05:30

Issue:-
Unix shell script is running fine while running in foreground but getting stopped while trying to run in the background.

Reasons:-
The script is trying to write on the terminal and as the script is being suppressed in background mode, its giving I/O error and getting stopped.

Resolution:-
---After it stopped, check in the processes ps -fu whats going on.You will be able to get the idea what might be causing the problem.

--- Normally the problem gets resolved if you do stty sane or disable some stty commands.

Some good links:-
script with rsh has error stty : : I/O error

Problems with nohup

HowToInfa: Informatica Best Practices

2009-07-08T14:33:00.006+05:30

Import not Copy:-

While deploying a mapping from Dev to QA or QA to Prod,always try to import first.
If you face any error in importing then copy the mapping from source to target environment.
The reason for that is while copying the sources and targets gets copied as NON-SHORTCUT whereas they should have been copied as shortcut.

There might be possibility that in your project you keep all your source/target/transformation/mapplets etc into a shared folder and you are using those components in different different mappings.

In copying they will be copied not as shortcut to that folder but a separate copy which definitely you dont want.

Set relational connection in UTF8 by default
This will avoid much data corruption issues.

Relational connection changes required?-Replace if possible

You may need somtime to fix some passwords/userid/codepage/parrallism in relational connection.
Create a new with your required changes.
Replace the old with this new.
Delete the new.
This will help you avoid validating a no of sessions which might be using the old relational connection.

HowToInfa : Undocked and now can not dock

2009-07-06T12:39:00.001+05:30

I got the solution from ITTOOLBOX.
docking problems with powercenter designer

And it is:-
1. close all Informatica instances like Designer , Workflow manager and monitor
2. backup the registry
3. go to HKEY_CURRENT_USER
4. go to SOFTWARE --> Informatica --> POWERMART CLIENT TOOLS --> (whichever version you are using) my case 7.1 -->Designer/Workflow Monitor/WFManager --> Toolbars 7.1
5. rename the folder Tolbars 7.1 to anything like toolbars 7.1_old
6. save and exit the registry editor
7. Restart Informatica Designer/WFManager/WFMonitor

HowToEpipOM: All available jobs through epichannel

2009-05-19T14:43:00.001+05:30

$ epichannel -help
-------------------------------------------------------------------------------
EpiChannel -help
EpiChannel Version 7.1.1.0.1293
-------------------------------------------------------------------------------
EpiChannel executes extraction jobs locally or remotely, runs MomentumBuilder,
AggregateBuilder, Scrutiny, RandomPerm, and CreateCurrentViews.

-------------------------------- Example Usage --------------------------------
Run a job:
EpiChannel -l -b -s
-u -d -p
-J
Run a job:
EpiChannel -i -j

Run MomBuilder in ForceRebuild mode:
EpiChannel -i -mom -fb

Run Scrutiny and check the Outbound Marketing Server, the Mart, and AggBuilder
EpiChannel -i -scr AppServer Mart AggBuilder

List completed, running, and pending EpiChannel tasks:
EpiChannel -i -ls -all

Run a job on the remote server:
EpiChannel -i -j -r

Attach to the job with ID 3579 and print its log files as it runs:
EpiChannel -i -a 3579

Kill the job with ID 3579:
EpiChannel -i -k 3579

Run a job; Override the mail configuration specified in the instance storage:
EpiChannel -i -j -mh mail.mydomain.com
-ma martin@mydomain.com -ms it_worked@mydomain.com
-mw something_wrong@mydomain.com -mf it_failed@mydomain.com

Usage Notes:
All command line parameters are case insensitive.
All command line parameters can begin with /, -, or --.
Command line parameters can appear in any order.
-------------------------------- Return Codes ---------------------------------
(0) EPICHANNEL_SUCCESS EpiChannel executed successfully
(1) EPICHANNEL_FAILURE EpiChannel failed as a result of a user or an
environmental error
(2) EPICHANNEL_USERCANCEL EpiChannel failed because it was canceled with
the --kill command.
(3) EPICHANNEL_RUNTIMEEXCEPTION
EpiChannel failed because of an internal error.
Send all log files to [906] Customer
Support.
-------------------------------------------------------------------------------
-h, -?, /?, --help Display this list of command-line options.
-------------------------------------------------------------------------------
-j, --Job Run the specified extraction job.
-t, --TrialRun Simulate execution of the SQL on the source and
destination databases without making any changes
to the data.
--LogRows Log the contents of the first rows of
every extraction statement.
-#, --MaxSelects
The maximum number of rows to fetch in any SQL
statement.
-f, --ForceRestart Ignore previous execution history and start
executing job from the beginning.
-------------------------------------------------------------------------------
-mom, --MomBuild Run MomentumBuilder. Generate or update the
accelerators required for generating lists and
campaigns.
-npt, --NumParallelThreads
The number of concurrent accelerator creation
queries issued.
-f, --ForceRestart Ignore previous execution history and build all
accelerators requested by the metadata
-fb, --ForceRebuild Rebuild accelerators from scratch. Do not
attempt to incrementally update.
--NoMirror Run MomBuilder against the currently active
datamart partition.
-------------------------------------------------------------------------------
-agg, --AggBuild Run AggregateBuilder. Build aggregate tables to
improve query response time.
-------------------------------------------------------------------------------
-scr, --Scrutiny ...
Run the specified internal consistancy checks on
the EpiCenter. consists of one or
more of the options below separated by spaces.
All Run all Scrutiny checks.
Meta Run Scrutiny checks on the metadata.
Mart:Next Run Scrutiny checks on the EpiMart (in the next
space).
Mart:Current Run Scrutiny checks on the EpiMart (in the
current space).
Mart:Prev Run Scrutiny checks on the EpiMart (in the
previous space).
Op Run Scrutiny checks on the EpiOp.
AppServer Run Scrutiny checks required by the Outbound
Marketing Server.
EpiChannel Run Scrutiny checks required for EpiChannel
extraction.
AggBuilder Run Scrutiny checks required by
AggregateBuilder.
MomBuilder Run Scrutiny checks required by MomentumBuilder.
SchemaGen Run Scrutiny checks required for adaptive schema
generation.
Warning Run Scrutiny checks for warnings in addition to
errors.
-------------------------------------------------------------------------------
-rnd, --RandPerm Build a random sampling table used for sampling
of demographic dimensions and for populating
random lists.
-------------------------------------------------------------------------------
-ccv, --CreateCurrentViews Rebuild external reporting views which select
the currently active versions of the base tables.
-------------------------------------------------------------------------------
-dae, --Daemon Spawn a daemon process that checks the metadata
for remote requests to execute EpiChannel, and
acts on those requests.
-------------------------------------------------------------------------------
-stop, --StopDaemon Request a running daemon to kill all the remote
jobs it has spawned and exit.
-------------------------------------------------------------------------------
-ls, --List List currently running and pending EpiChannel
executions.
--All Show completed instances as well.
-------------------------------------------------------------------------------
-a, --Attach Attach to and print the logs from the specified
execution instance of EpiChannel. The instance
can be currently running or completed. Get
by executing the --List command.
-------------------------------------------------------------------------------
-k, --Kill Kill the specified running instance of
EpiChannel. Get by executing the
--List command.
------------------------------- General Options -------------------------------
-b, --DBVendor The name of the vendor of the dbms on which the
SQLServer EpiMeta database resides.
Oracle
-s, --Server The name of the server where the EpiMeta
database resides.
-u, --UserName The username of the EpiMeta database. Pass ""
to request the use of operating system level
authentication.
-d, --DBName The database name of the EpiMeta database.
This parameter is not required on Oracle.
-p, --Password The password for the user of the EpiMeta database
-pt, --Port The port to use to connect to the EpiMeta
database. If not supplied, database type default
is used.
-disableDBLog Disable logging to the Epiop database
-int, --Interactive Run EpiChannel in interactive mode. This is
incompatible with the --RemoteLaunch option and
the --Noninteractive option.
-nonint, --Noninteractive Disable use of interactive mode for job steps
whose debug level is set to interactive. This
option is incompatible with the --Interactive
option.
-r, --RemoteLaunch Request that the remote daemon process launch an
EpiChannel instance with the specified command
line (excluding --RemoteLaunch and its options).
-dt, --Detach Dont attach to the remotely spawned process and
dont print its log files. Send the request to
the Daemon process and exit immediately.
-dwc, --DieWithClient Request that the remotely spawned EpiChannel
execution instance kill itself if the connection
with this client is lost.
-i, --InstanceName The name of an EpiCenter instance stored
locally. Connection information and other
EpiChannel options are taken from this local set
of defaults. Options specified via command line
parameters override options specified inside the
local instance storage.
--InstallRootDir
The directory in which this version of [906]
Outbound Marketing is installed.
-l, --LoggingDir
The directory where logging files will be
created.
--DisableDBLog Disables logging to the EpiOp data store. This
option should only be necessary if DB-Logging is
causing short jobs that would otherwise run
in only a few minutes to run for a long time.
-sch, --Scheduler Directs EpiChannel to fail if a previously
failed job failed on a job step that had OnError
action set to ManualRepeat. This should be used
whenever EpiChannel is being called from an
automated scheduler.
-ma, --MailAdmin The e-mail address of the administrator for your
application, which is used as the return address
for automatic e-mail notification of job status.
-mh, --MailHost The hostname of the SMTP host computer through
which e-mail is to be sent.
-ms, --MailSuccess
The address to which an e-mail containing
EpiChannel log files is to be sent on successful
completion of an extraction job. Multiple
addresses can be separated by commas (without
spaces).
-mw, --MailWarning
The address to which an e-mail containing a
warning message is to be sent when a warning is
generated during execution of an extraction job.
Multiple addresses can be separated by commas
(without spaces).
-mf, --MailFailure
The address to which an e-mail containing
EpiChannel log files is to be sent on failure of
an extraction job. Multiple addresses can be
separated by commas (without spaces).
-------------------------------------------------------------------------------
EpiChannel| |Completed|
| | |

HowToOracle: Tidbits In Oracle

2009-04-29T11:11:00.009+05:30

Before Inserting Chinese Character:-

Set the client machine locale to UTF-8.
In Unix
LANG=en_US.UTF-8;export LANG
In Windows:-
chcp 65001

Link
Changing your locale on Windows

Can not see chinese character in my TOAD/SQLPLUS/SQL NAVIGATOR etc

To see that you have to change the NLS_LANG for the oracle client machine (may be your local windows machine or the Unix client; basically where client is installed)

Where to set the NLS_LANG in Windows
[ Taken from nls_lang faq ]

In the Registry:

On Windows systems, you should make sure that you have set an NLS_LANG registry subkey for each of your Oracle Homes:

You can easily modify this subkey with the Windows Registry Editor:

Start -> Run...

Type "regedit", and click "ok"

Edit the following registry entry:

For Oracle version 7:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

For Oracle Database versions 8, 8i and 9i:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEx\

where "x" is the unique number identifying the Oracle home.

HOME0 is the first installation

For Oracle Database 10g:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_

There you have an entry with name NLS_LANG

What to change:-
[ Taken from Toad wiki ]

Reset NLS_LANG on your Client machine to AMERICAN_AMERICA.JA16SJIS to view Japanese and AMERICAN_AMERICA.ZHT16BIG5 to view Chinese.

The true bengali......

2009-04-25T22:56:00.004+05:30

I got this article from other blog.From Fake IPL Player - In some comments
And I could not but laughing reading that.Its an amazing description of BANGALEES and veryy veryy true.
Very beutifully written.

A is for Awpheesh (as in Office). This is where the average Kolkakatan goes and spends a day hard at work. And if he works for the 'Vest Bengal Gawrment' he will arrive at 10, wipe his forehead till 11, have a tea break at 12, throw around a few files at 12.30, break for lunch at 1, smoke the 7th unfiltered cigarette at 2, break for 5th cup of tea at 3, sleep sitting down at 4 and go home at 4:30. It's a hard life!

B is for Bhision. For some reason many Bengalis don't have good bhision. In fact in Kolkata most people are wearing spectacles all the time....Bhishon Bhalo and Bibhotso.... though means opposite ...used for same situations.. .depending on the Beauty of fairer sex...are close ...almost in a tie for second spot....

C is for Chappell. Currently, this is the Bengali word for the Devil, for the worst form of evil. In the night mothers put their kids to sleep saying, 'Na ghumoley ebar Chappell eshey dhorey niye jabe.'

D is for Debashish or any other name starting with Deb. By an ancient law every fourth Bengali Child has to be named Debashish. So you have a Debashish everywhere and trying to get creative they are also called Deb, Debu, Deba with variations like Debopriyo, Deboprotim, Debojyoti, etc. thrown in at times....as creations of God himself !!

E is for Eeesh. This is a very common Bengali exclamation made famous by Aishwarya Rai in the movie Devdas. It is estimated that on an average a Bengali, especially Bengali women, use eeesh 10,089 times every year. 'Ei Morechhey' is a close second to Eeesh.

F is for Feeesh. These are creatures that swim in rivers and seas and are a favourite food of the Bengalis. Despite the fact that a fish market has such strong smells, with one sniff a Bengali knows if a fish is all right. If not, he will say 'eeesh what feeesh is theesh!'

G is for Good name. Every Bengali boy will have a good name like Debashish or Deboprotim and a pet name like Motka, Bhombol, Thobla, etc. While every Bengali girl will have pet names like Tia, Tuktuki, Mishti, Khuku, et cetera.

H is for Harmonium. This Bengali equivalent of a rock guitar. Take four Bengalis and a Harmonium and you have the successors to The Bheatles!

I is for Ileesh. This is a feeesh with 10,987 bones which would kill any ordinary person, but which the Bengalis eat with releeesh!

J is for Jhola. No selfrespecting Bengali is complete without his Jhola. It is a shapeless cloth bag where he keeps all his belongings and he fits an amazing number of things in. Even as you read this there are two million jholas bobbling around Kolkata, and they all look exactly the same! Note that 'Jhol'with mysterious condiments.. . as in Maachher Jhol is a close second. Jhaamela and Jachhetai are distant 3rd and 4th

K is for Kee Kaando! It used to be the favourite Bengali exclamation till eeesh took over because of Aishwarya Rai.Kee mushkil is a close second.

L is for Lungi, the dress for all occasions. People in Kolkata manage to play football and cricket wearing it not to mention the daily trip in the morning to the local bajaar. Now there is talk of a lungi expedition to Mt Everest.

M is for Minibaas. These are dangerous half buses whose antics would effortlessly frighten the living daylights out of all James Bond stuntmen as well as Formula 1 race car drivers.

N is for Nangto. This is the Bengali word for Naked. It is the most interesting naked word in any language!

O is for Oil. The Bengalis believe that a touch of mustard oil will cure anything from cold (oil in the nose), to earache (oil in the ear), to cough (oil on the throat) to piles (oil you know where!).

P is for Phootball. This is always a phavourite phassion of the Kolkattan. Every Bengali is born an expert in this game. The two biggest clubs there are MOHUNBAGAN and East Bengal and when they play the city comes to a stop.

Q is for Koshchen (question) as in "Mamatadi koshchens Cheap Ministaar in Writaars Buiding."

R is for Robi Thakur. Many many years ago Rabindranath got the Nobel Prize. This has given the right to all Bengalis no matter where they are to frame their acceptance speeches as if they were directly related to the great poet and walk with their head held high. This also gives Bengalis the birthright to look down at Delhi and Mumbai and of course 'all non-Bengawlees'! Note that 'Rawshogolla' comes a close second!

S is for Shourav. Now that they finally produced a genuine cricketer, that too a captain, Bengalis think that he should be allowed to play until he is 70 years old.

T is for Trams. Hundred years later there are still trams in Kolkata. Of course if you are in a hurry it's faster to walk....Trams are still existing in Paris too.......you see !

U is for Aambrela. When a Bengali baby is born he is handed one.

V is for Bhaayolence. Bengalis are the most non-violent violent people around. When an accident happens they will fold up their sleeves, shout and scream and curse and abuse, "Chherey De Bolchhi" but the last time someone actually hit someone was in 1939.

W is for Water. For three months of the year the city is underwater and every year for the last 200 years the authorities are taken by surprise by this!

X is for X'mas. It's very big in Kolkata, with Park Street fully lit up and all Bengalis agreeing that they must eat cake that day.

Y is for Yesshtaarday. Which is always better than today for a Bengali (see R for Robi Thakur)?. It is also for Jubraj Shingh and Joga.

Z is for Jebra, Joo, and Jipper.

HowToEpiphany:- Added new user,but can not access using thin client

2009-04-16T13:06:00.002+05:30

You have added a new user in OM.
But when the user is trying to access epiphany using thin client login error is coming.

Check:-
Check the credentials of that user in OM again.
If its a NT LM access check for the domain.
If its LDAP access check the details.

And then refresh the OM.

HowToEpiphany:- Can not start OM Service.

2009-04-16T11:01:00.004+05:30

You trying to start the service but can not and its says like "Error-1053 The service did not respond to the start or control request in a timely fashion".

If windows can not start a service for 3 minutes it will throw error.
Wait and refresh the service.It may get start a bit later.

If it is not starting then
Check the administrative tools-->event viewer logs
Try to find out the error and resolve this.
Possible error may be:-
1/ Scrutiny error.
2/ Database connectivity.
3/ Another instance of weblogic/websphere is running. etc.

HowToEpiphany:- Can not connect from epiphany thin client

2009-04-16T10:57:00.002+05:30

You may get error like:-
Message from the ISAPI plugin:

No backend server available for connection: timed out after 20 seconds.

Build date/time: Jun 21 2002
Change Number: 191629

Check:-
1/ SSA Global OM server is running.
2/ Weblogic/Websphere is running.

HowToEpiphany: Installing SSA Outbound Marketing In Windows

2009-04-15T21:47:00.002+05:30

1. Prepare your database:
a.

2. Prepare your window for OM:-
3. Installing a web server
a. Install IIS.After rebooting Windows, verify that service w3svc (World Wide Web Publishing Service) is set to Automatic. If it is not, set it to automatic using the (right-click) Properties dialog box. IIS does not work properly unless this service is running.
b. Setting web site protection:-
i. Navigate to (Windows) Start > Programs > Administrative Tools >Internet Services Manager.
ii. For each Web site created for use with a different Outbound Marketing instance, right-click and select Properties.
iii. Open the Home Directory tab and set Application Protection to High. If this setting is changed to High (Isolated) from another value, ensure that the change is propagated to all child scripts.
iv. Click OK to save your settings.
v. Stop and restart IIS after completing the above steps for all Web sites intended for use with Outbound Marketing instances

4. Install Oracle client if your OM datamart is not in this machine.
5. Installing the J2EE Application Server
a. Run the installer and follow the prompts displayed in the installer window. Accept the installation defaults or select options to comply with the standards for your enterprise. At a minimum, you must install the WebLogic server Server component. Node Manager is required and is part of the installation, but you do not need to install it as a Windows Service.
b. Install the WebLogic license. Change the name of your new downloaded license file from license.bea to license_new.bea. Run UpdateLicense.cmd license_new.bea. This peration merges the new license with current license, and saves the results in the file license.bea. The new merged file license.bea will be used by Weblogic.
6. Creating a WebLogic Domain
Note: Perform this procedure after installing BEA WebLogic and before
installing Outbound Marketing. To upgrade to the current release of
Outbound Marketing from any previous version, complete this procedure
before using the Outbound Marketing Instance Manager.
a. Start the BEA WebLogic Configuration Wizard through one of the following methods:
Windows Start menu:
Start > All Programs > BEA Products > Tools > Configuration Wizard
Windows command line:
\ wlserver_10.0\common\bin\config.cmd
Unix command line:
/wlserver_10.0/common/bin/config.sh
b. On the Welcome screen, select Create a new WebLogic domain, and click Next.
c. On the Domain Source screen, accept the default (selects Generate a domain configured automatically to support the following BEA Products:), and click Next.
d. Enter an administrative user name and password in the Configure Administrative Username and Password screen, and click Next. Store this information for logging on to the Administrative Console.
e. On the Configure Server Start Mode and JDK screen, do the following and click Next.
i. In the WebLogic Configuration Startup Mode pane, select Development Mode.
ii. Select the Java SDK to use.
In the JDK Selection pane, select BEA Supplied JDKs, and then the installed version of the SUN SDK.
f. On the Customize Environment and Services Settings screen, accept the default and click Next.
g. On the Create WebLogic Domain screen, enter a unique Domain Name. (The default is base_domain.) Do not modify the path information in the Domain Location field.
h. Click Create to complete the process and create the new domain. The new domain is used as a template domain and is not modified by Outbound Marketing.

7. Installing outbound marketing manager:-

The standard software installation (collectively called the Outbound Marketing)
on Windows includes:
- Outbound Marketing Server, an application server that coordinates user requests for data and reports, returns results in HTML format, and supports navigation between EpiCenter Web pages.
- Outbound Marketing Manager, a graphical administrative utility for configuring and managing the data mart and applications. Because the Outbound Marketing Manager runs on Windows, the Oracle configuration scripts are only present in the Windows package.
- EpiChannel, an extraction facility for downloading data from source systems into the data mart.
- Remote Web Server, a link to the installed Web server.
- Other Outbound Marketing components and utilities including language-specific files.
Note:
- Outbound Marketing software does not have to be installed on the same computer as the data mart (EpiCenter). However, for DB2, you must catalog the DB2 server on the DB2 client machine, including all of the machines in a cluster prior to installation.The installer automatically installs, or offers to install, the following required third-party software components if they are not already present:
- ODBC and JDBC drivers
- After installing Outbound Marketing software on the server host, install the Outbound Marketing Manager administrative utility on other computers to provide remote access for administrative tasks.

a. Log in under an account that has administrator privileges on the local host.
b. Get the AS_win32_nas.zip file for the installation. The zip file is available from the Infor Download Center.
c. Unzip the file to C:\\Install (the default directory), or a directory of your choice.
d. Exit all open Windows applications.
e. Make sure you have installed and configured your J2EE application server, Web server, and database management server before continuing.
Note: For the WebSphere Network Deployment application server, be sure the deployment manager and node agents are running before beginning the installation.
f. Verify that you have the Java 1.5 runtime environment installed. If necessary download and install Java 1.5 before continuing.
g. Verify that the World Wide Web Publishing Service is running. If the service is not running, navigate to Start > Programs > Administrative Tools > Services to start the service.
h. Double-click ominstall.exe in the directory specified in step c
i. A message window prompts you to set JAVA_HOME to Java 1.5 JRE/ JDK, if you have not already set JAVA_HOME.Click OK to close the OM installer. Install Java 1.5 JRE/JDK and set JAVA_HOME. Re-start the OM installer .
Note: If sunjce_provider.jar does not exist at /jre/lib/ext when JAVA_HOME points to a JDK directory, or at /lib/ext when JAVA_HOME points to a JRE directory, then you will see the following error message if you try to install OM:

ERROR: C:\java\jdk1.5.0_11/jre/lib/ext/sunjce_provider.jar does not exist. Download the file from Sun and try again. Click the OK button in the error window to stop and exit the OM installer. Then, download sunjce_provider.jar from the Sun website, install the file, and try running the OM installer again.
j. Install Microsoft Data Access Components (MDAC) 2.8, if prompted. The installation files and license are included.
i. Follow the screen prompts to install MDAC.
ii. Reboot when prompted.
iii. Restart ominstall.exe. The InstallAnywhere wizard displays the Welcome screen.
Tip: Click Cancel at any time during the installation process to terminate and uninstall any components installed to that point.
k. Click Next. The InstallAnywhere wizard displays Destination Folder screen.

UnixHowTo:Find version of OS

2009-04-14T07:10:00.000+05:30

[abul@abc~]$ cat /proc/version
Linux version 2.6.9-34.ELsmp (bhcompile@hs20-bc1-7.build.redhat.com) (gcc version 3.4.5 20051201 (Red Hat 3.4.5-2)) #1 SMP Fri Feb 24 16:54:53 EST 2006

HowToGeneral:- Internet Connection Sharing

2009-01-11T19:48:00.006+05:30

If you have wireless connection with a USB Modem.And you want your computer to act as a router and wish other can also connect to internet through your computer,read the following article:-

Practically Networked

HowToOracle:- When to use Bitmap Index

2008-12-05T12:31:00.003+05:30

Good Notes

HowToOracle:Get the numeric value alone in a alphanumeric string

2008-12-03T13:39:00.002+05:30

Writing Better SQL Using Regular Expressions

Pictography 2

2008-11-27T07:53:00.001+05:30

Sharable_Amateur

HowToOracle:Underlying query tuning in Oracle

2008-05-24T17:35:00.005+05:30

A tons of materials are there in net.
I found the followings are good enough to tell the internals and explains the basics:-
http://philip.greenspun.com/sql/tuning.html
http://www.billmagee.co.uk/oracle/sqltune/index.html

The following site describes how a query can be re-written in different ways:-
http://www.wisc.edu/drmt/oratips/sess006.html

The Orafaq page which answers why oracle dont use an index or in other way when a developer should go for index and when not.
http://www.orafaq.com/wiki/Oracle_database_Performance_Tuning_FAQ

And finally Oracle`s doc:-
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/sql_1016.htm#g42927

My Own research:-
The performance of a query against a oracle database depends
*> on the hardware
*> The database parameters.
*> the query you are firing.

Database parameters usually defined according to the future query which will may be fired against it.

I did some experiments on query level.

1/ Avoid view to use in query if possible.And if there is a multiple layer of views where the results is coming up from other views it becomes much more costly.

SQL> SELECT DISTINCT e.deptno, dname deptname
2 FROM scott.dept D,
3 scott.emp E
4 WHERE D.deptno = E.deptno;

DEPTNO DEPTNAME
---------- --------------
10 ACCOUNTING
20 RESEARCH
30 SALES

Elapsed: 00:00:00.01

Execution Plan
----------------------------------------------------------
Plan hash value: 652980069

-----------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-----------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 9 | 135 | 5 (20)| 00:00:01 |
| 1 | HASH UNIQUE | | 9 | 135 | 5 (20)| 00:00:01 |
| 2 | NESTED LOOPS | | 14 | 210 | 4 (0)| 00:00:01 |
|* 3 | TABLE ACCESS FULL | EMP | 14 | 28 | 3 (0)| 00:00:01 |
| 4 | TABLE ACCESS BY INDEX ROWID| DEPT | 1 | 13 | 1 (0)| 00:00:01 |
|* 5 | INDEX UNIQUE SCAN | PK_DEPT | 1 | | 0 (0)| 00:00:01 |
-----------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

3 - filter("E"."DEPTNO" IS NOT NULL)
5 - access("D"."DEPTNO"="E"."DEPTNO")

Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
23 consistent gets
0 physical reads
0 redo size
540 bytes sent via SQL*Net to client
381 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
3 rows processed

SQL> create view test_view as SELECT DISTINCT e.deptno, dname deptname
2 FROM scott.dept D,
3 scott.emp E
4 WHERE D.deptno = E.deptno;

View created.

Elapsed: 00:00:00.07
SQL> select * from test_view;

DEPTNO DEPTNAME
---------- --------------
10 ACCOUNTING
20 RESEARCH
30 SALES

Elapsed: 00:00:00.01

Execution Plan
----------------------------------------------------------
Plan hash value: 1801966990

--------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 9 | 198 | 5 (20)| 00:00:01 |
| 1 | VIEW | TEST_VIEW | 9 | 198 | 5 (20)| 00:00:01 |
| 2 | HASH UNIQUE | | 9 | 135 | 5 (20)| 00:00:01 |
| 3 | NESTED LOOPS | | 14 | 210 | 4 (0)| 00:00:01 |
|* 4 | TABLE ACCESS FULL | EMP | 14 | 28 | 3 (0)| 00:00:01 |
| 5 | TABLE ACCESS BY INDEX ROWID| DEPT | 1 | 13 | 1 (0)| 00:00:01 |
|* 6 | INDEX UNIQUE SCAN | PK_DEPT | 1 | | 0 (0)| 00:00:01 |
--------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

4 - filter("E"."DEPTNO" IS NOT NULL)
6 - access("D"."DEPTNO"="E"."DEPTNO")

Statistics
----------------------------------------------------------
8 recursive calls
0 db block gets
25 consistent gets
0 physical reads
0 redo size
540 bytes sent via SQL*Net to client
381 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
3 rows processed

SQL> spool off

2/ Use bind variables if your specific query is about to execute many times inside a loop.
Because when you use bind variables oracle picks up earlier query from shared pool.See the following example and look for the time taken after using bind variable.

The DDL of src_rand table is
SL_NO NUMBER(7),
RANDNUM VARCHAR2(14 BYTE),
RANDSTR VARCHAR2(45 BYTE)

SQL> select * from scott.src_rand where rownum < 4;

SL_NO RANDNUM RANDSTR
---------- -------------- ---------------------------------------------
556 kbtnpfiddmfu 371555940865.396909387092321361009129498
557 ylxiddflorsp 462786513408.184026987188015346255644919
558 detqtvbxxtpa 686749281069.89158302932789178713581963

Elapsed: 00:00:00.64

SQL> declare
2 i number(8) := 0;
3 begin
4 for i in 1..10000 loop
5 execute immediate
6 'select sl_no from scott.src_rand where sl_no='||i;
7 end loop;
8 end;
9 /

PL/SQL procedure successfully completed.

Elapsed: 00:00:10.65
SQL> declare
2 i number(8) := 0;
3 begin
4 for i in 1..10000 loop
5 execute immediate
6 'select sl_no from scott.src_rand where sl_no = :x' using i;
7 end loop;
8 end;
9 /

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.37
SQL> spool off

HowToOracle:How to check explain plan in sql* plus?

2008-05-24T16:12:00.001+05:30

Check on Burleson page on SQL Execution Plans
http://www.dba-oracle.com/plsql/t_plsql_plans.htm

UnixHowTo:Find the uptime of linux/unix server?

2008-04-17T02:57:00.001+05:30

Check from the following link:-
http://www.cyberciti.biz/faq/server-uptime-command-to-find-out-how-long-the-system-has-been-running/

HowToUnix: Problem in file removal -sh: /bin/rm: Argument list too long

2008-03-28T02:46:00.005+05:30

Error:-
Was getting -sh: /bin/rm: Argument list too long error while trying to delete more than 60K files.

Resolution:-
find . -name "*.abc" -exec rm {} \;
Which will remove all files ending with 'abc'.
Check the following link
Argument list too long

HowToUnix: Problem in file moving -sh: /bin/mv: Argument list too long

2008-03-28T02:40:00.004+05:30

Error:-
Was getting that error while trying to move more than 60K files.

Resolution:-
find [abc]* -depth | cpio -pdumav /your/target/directory

Informatica 7.1.5:How to replace the old connection with a new one

2008-03-02T06:02:00.001+05:30

How to replace the existing connection with a new
one without redefining all source/target/lookup connections in every
session?

All connections whichsover you will create will be stored into INfa meta.And thus any any changes in connection will make sessions invalid.
In that case after creating your new relational connection,replace the old one with new one.You can do that from the menu CONNECTION.

informatica 7.1 : While starting Informatica service getting error as " the informatica service started and then stopped"

2008-02-17T04:21:00.002+05:30

Check:-

1/
Are all folders like TgtFiles,SrcFiles,Temp,Cache,WorkflowLogs,LkpFiles,SessLogs etc in place?

2/The repository you have created is there in Informatica server setup?

HowToUnix: GPG Automation

2008-02-01T06:56:00.000+05:30

While automating encryption I faced the following issues.

$ gpg -q --yes -e -r Hasim File.txt
gpg: C2E7FAEF: There is no indication that this key really belongs to the owner
1024g/C2E7FAEF 2006-04-24 "Abul Hasim Molla "
Primary key fingerprint: B294 D02D D129 6224 B522 AE1F 4918 1E24 020C 23DC
Subkey fingerprint: 729E 52BF A281 0B2C 2073 7E27 262E DD2B 22E7 FCDF

It is NOT certain that the key belongs to the person named
in the user ID. If you *really* know what you are doing,
you may answer the next question with yes

Use this key anyway? y

I tried with so many options of gpg like as --no-tty,-q,---yes and so on.
Finally I solved it as follows:-

1/ You have to say that you trust the key and know the recipient well. Thats the solution.
To do so:-
gpg --edit-key NAME
$gpg --edit-key Hasim

gpg (GnuPG) 1.2.6; Copyright (C) 2004 Free Software Foundation, Inc.
This program comes with ABSOLUTELY NO WARRANTY.
This is free software, and you are welcome to redistribute it
under certain conditions. See the file COPYING for details.

pub 1024D/0A0C23AC created: 2006-04-24 expires: never trust: -/-
sub 1024g/C2E7FAEF created: 2006-04-24 expires: never
(1). Abul Hasim Molla

Means your key status as per gpg is undefined and unknown.

2/ And then you will be take to the command mode.

Command> trust
pub 1024D/0A0C23AC created: 2006-04-24 expires: never trust: -/-
sub 1024g/C2E7FAEF created: 2006-04-24 expires: never
(1). Abul Hasim Molla

Please decide how far you trust this user to correctly
verify other users' keys (by looking at passports,
checking fingerprints from different sources...)?

1 = Don't know
2 = I do NOT trust
3 = I trust marginally
4 = I trust fully
5 = I trust ultimately
m = back to the main menu

Your decision?

3/ Say you trust him/her.
Your decision? 5
Do you really want to set this key to ultimate trust? y

pub 1024D/0A0C23AC created: 2006-04-24 expires: never trust: u/-
sub 1024g/C2E7FAEF created: 2006-04-24 expires: never
(1). Abul Hasim Molla
Please note that the shown key validity is not necessarily correct
unless you restart the program.

Command>quit

And your problem is resolved.

HowToUnix: Can't locate DBI.pm in @INC

2007-10-24T03:50:00.000+05:30

While running a perl program having some database connectivity in it I faced the following error:-

Can't locate DBI.pm in @INC (@INC contains:
/usr/lib/perl5/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/5.8.5
/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.5
/usr/lib/perl5/site_perl/5.8.4
/usr/lib/perl5/site_perl/5.8.3
/usr/lib/perl5/site_perl/5.8.2
/usr/lib/perl5/site_perl/5.8.1
/usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.5
/usr/lib/perl5/vendor_perl/5.8.4
/usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/vendor_perl/5.8.2
/usr/lib/perl5/vendor_perl/5.8.1
/usr/lib/perl5/vendor_perl/5.8.0
/usr/lib/perl5/vendor_perl .)

Later I found we do not have DBI.pm installed.
We have installed that and the problem got respolved.

The page where from we took help is :-

Setting up DBD::Oracle on Linux

UnixHowTo: How to find a particular word in a list of files in UNIX?

2007-10-24T01:09:00.000+05:30

I am about to find the string "sqlplus" in a list of shell scripts:-

$ find . -name "*.sh" -print | xargs grep -l sqlplus

./hasimsampleshell1.sh
./hasimsampleshell2.sh

$ find . -name "*.sh" -print | xargs grep sqlplus

./hasimsampleshell1.sh: $ORACLE_HOME/bin/sqlplus -s scott/tiger@localhost @testsql2.sql

./hasimsampleshell2.sh: $ORACLE_HOME/bin/sqlplus -s scott/tiger@localhost @testsql2.sql

Unix HowTo: Date substraction addition in UNIX

2007-10-18T01:16:00.000+05:30

This is done using perl code snippet.

$ cat dateSubs.sh
TODAYS_DATE=`date|cut -d" " -f2,3,6|sed 's/ /-/g'`
a=`perl -e 'printf "%s", scalar localtime(time-604800)'`
WEEKS_BEFORE=`echo $a|cut -d" " -f2,3,5|sed 's/ /-/g'`

echo "TODAYS_DATE : $TODAYS_DATE"
echo "WEEKS_BEFORE: $WEEKS_BEFORE"

Result:-
$ dateSubs.sh
TODAYS_DATE : Oct-17-2007
WEEKS_BEFORE: Oct-10-2007
---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

Unix How To:- How to connect to remote without providing PASSPHRASE through SSH/SFTP?

2007-10-04T02:12:00.000+05:30

1/Say you want to connect to REMOTE from LOCAL through SSH.
2/Create pub-priv key pair in ~/.ssh directory in LOCAL.
**** DONT GIVE ANY PASSPHRASE ****
* DONT CHANGE THE DEFAULT FILE NAME WHERE PUB/PRIV KEY WILL BE SAVED *

LOCAL> ssh-keygen
Generating public/private rsa key pair.
Please be patient.... Key generation may take a few minutes
Enter file in which to save the key (/mnt/abstract/home/abstractinfo/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /mnt/abstract/home/abstractinfo/.ssh/id_rsa.
Your public key has been saved in /mnt/abstract/home/abstractinfo/.ssh/id_rsa.pub.
The key fingerprint is:
db:b3:12:a1:39:e6:4c:f5:96:1b:44:fa:e1:52:3d:9a abstractinfo@LOCAL
LOCAL> l
total 18
-rw------- 1 abstractinfo abstractinfo 1024 Oct 1 2004 prng_seed
-rw-r--r-- 1 abstractinfo abstractinfo 4656 Oct 3 14:56 known_hosts
-rw------- 1 abstractinfo abstractinfo 1751 Oct 3 15:02 id_rsa
-rw-r--r-- 1 abstractinfo abstractinfo 396 Oct 3 15:02 id_rsa.pub

LOCAL> cat id_rsa.pub
ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEA7ZwfwrbB+Q1DVjvQI5qk5UL2arq1HYbUoFeJGAl70p+pHjRqqAl9lZkvUv8Fet0fy8S70ukzE7eCqsGA0Mfh5LJBDgcH41cfTPo5nacihjSwzbWfo9zKl+rGYTBdZ2SOxvyeGxrwhJH5kLkclG6obmIy1Z2Mhlm4y1gYt576fgk598976VWIajFZT4igTAKqGmkFM7TlnZGLPktfw1YfOPqVS3fR4s5+WKeUJ19qsUqdCJBhvWjiAKFuWQft9DTW0k5w4QtxuJIMvslPUNKZz2EEwsWvpk9tVB7dORuUtBIvvGUrNY0DiXytNQjz5ar94P2qtDdDQyv8PPUWw== abstractinfo@LOCAL
3/Append that public key in REMOTE MACHINE`s ~/.ssh/authorized_keys file.
** If that ~/.ssh/authorized_keys file is not there create it with 640 permission **

REMOTE> cat authorized_keys
ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEAtww1sd36jrpwPfJ7ILka5iGFvVSUL4jYd3fpLm0cHLRw08oKkmCvki9w02S97MSqPADKHA6Dax5kYrv0wJQmTrAo6niPmUjhDrXYJomQLbIIdiUDEeFP7kPtar9UY5ybU56bzaj/lvCNTgdNjXxiUJG7ZdkfBLiLiHRC4nTRLGciAbD2W2I4zff9E3+xv8PB20JYgq+07gjqjHtFXCkoGlmzz+vfzUWmDtvuHF+xr7TGd6VRom/9bH91xFPAdOKQ4DRJpf/9W1NGe6Jp/ToCQsRjf8kxQra250FoJW1tyx6vx3uHrnN08QUo37KMPe3ekjYHOUHLutNYj8ffiYZA+w== abstractinfo@LOCAL
REMOTE> l authorized_keys
-rw-r----- 1 abulhasi abstractinfo 396 Oct 3 15:05 authorized_keys

4/Test it from LOCAL.

LOCAL> ssh -v abulhasi@REMOTE
OpenSSH_4.4p1-hpn12v11, OpenSSL 0.9.7l 28 Sep 2006
HP-UX Secure Shell-A.04.40.006, HP-UX Secure Shell version
debug1: Reading configuration data /opt/ssh/etc/ssh_config
debug1: Connecting to REMOTE [##.##.###.###] port 22.
debug1: Connection established.
debug1: identity file /mnt/abstract/home/abstractinfo/.ssh/identity type -1
debug1: identity file /mnt/abstract/home/abstractinfo/.ssh/id_rsa type 1
debug1: identity file /mnt/abstract/home/abstractinfo/.ssh/id_dsa type -1
debug1: Remote protocol version 1.99, remote software version OpenSSH_4.4p1-hpn12v11
debug1: match: OpenSSH_4.4p1-hpn12v11 pat OpenSSH*
debug1: Enabling compatibility mode for protocol 2.0
debug1: Local version string SSH-2.0-OpenSSH_4.4p1-hpn12v11
debug1: SSH2_MSG_KEXINIT sent
debug1: SSH2_MSG_KEXINIT received
debug1: kex: server->client aes128-cbc hmac-md5 none
debug1: kex: client->server aes128-cbc hmac-md5 none
debug1: SSH2_MSG_KEX_DH_GEX_REQUEST(1024<1024<8192) sent
debug1: expecting SSH2_MSG_KEX_DH_GEX_GROUP
debug1: SSH2_MSG_KEX_DH_GEX_INIT sent
debug1: expecting SSH2_MSG_KEX_DH_GEX_REPLY
debug1: Host 'REMOTE' is known and matches the RSA host key.
debug1: Found key in /mnt/abstract/home/abstractinfo/.ssh/known_hosts:18
debug1: ssh_rsa_verify: signature correct
debug1: SSH2_MSG_NEWKEYS sent
debug1: expecting SSH2_MSG_NEWKEYS
debug1: SSH2_MSG_NEWKEYS received
debug1: SSH2_MSG_SERVICE_REQUEST sent
debug1: SSH2_MSG_SERVICE_ACCEPT received
debug1: Authentications that can continue: publickey,password,keyboard-interactive,hostbased
debug1: Next authentication method: publickey
debug1: Trying private key: /mnt/abstract/home/abstractinfo/.ssh/identity
debug1: Offering public key: /mnt/abstract/home/abstractinfo/.ssh/id_rsa
debug1: Server accepts key: pkalg ssh-rsa blen 247
debug1: read PEM private key done: type RSA
debug1: Authentication succeeded (publickey).
debug1: Final hpn_buffer_size = 131072
debug1: channel 0: new [client-session]
debug1: Entering interactive session.
Warning: No xauth data; using fake authentication data for X11 forwarding.
debug1: Requesting X11 forwarding with authentication spoofing.
Last login: Wed Oct 3 14:59:05 2007 from LOCAL
Last login: 3 Oct 14:59
REMOTE>

5/Once that succeeds you may have your automated SFTP script as follows:-

LOCAL> cat hasimsftp.sh
# -v is for verbose mode and -b is for all the commands in a batchfile.
sftp -v -b sftpcommandbatch.dat abulhasi@REMOTE <
LOCAL> cat sftpcommandbatch.dat
lcd /mnt/abstract/home/abstractinfo
cd /home/abulhasi
mput a.sql
ls -lrt

6/Test that:-
LOCAL> hasimsftp.sh
OpenSSH_4.4p1-hpn12v11, OpenSSL 0.9.7l 28 Sep 2006
HP-UX Secure Shell-A.04.40.006, HP-UX Secure Shell version
debug1: Reading configuration data /opt/ssh/etc/ssh_config
debug1: Connecting to REMOTE [##.##.###.###] port 22.
debug1: Connection established.
debug1: identity file /mnt/abstract/home/abstractinfo/.ssh/id_rsa type 1
debug1: identity file /mnt/abstract/home/abstractinfo/.ssh/id_dsa type -1
debug1: Remote protocol version 1.99, remote software version OpenSSH_4.4p1-hpn12v11
debug1: match: OpenSSH_4.4p1-hpn12v11 pat OpenSSH*
debug1: Enabling compatibility mode for protocol 2.0
debug1: Local version string SSH-2.0-OpenSSH_4.4p1-hpn12v11
debug1: SSH2_MSG_KEXINIT sent
debug1: SSH2_MSG_KEXINIT received
debug1: kex: server->client aes128-cbc hmac-md5 none
debug1: kex: client->server aes128-cbc hmac-md5 none
debug1: SSH2_MSG_KEX_DH_GEX_REQUEST(1024<1024<8192) sent
debug1: expecting SSH2_MSG_KEX_DH_GEX_GROUP
debug1: SSH2_MSG_KEX_DH_GEX_INIT sent
debug1: expecting SSH2_MSG_KEX_DH_GEX_REPLY
debug1: Host 'REMOTE' is known and matches the RSA host key.
debug1: Found key in /mnt/abstract/home/abstractinfo/.ssh/known_hosts:18
debug1: ssh_rsa_verify: signature correct
debug1: SSH2_MSG_NEWKEYS sent
debug1: expecting SSH2_MSG_NEWKEYS
debug1: SSH2_MSG_NEWKEYS received
debug1: SSH2_MSG_SERVICE_REQUEST sent
debug1: SSH2_MSG_SERVICE_ACCEPT received
debug1: Authentications that can continue: publickey,password,keyboard-interactive,hostbased
debug1: Next authentication method: publickey
debug1: Offering public key: /mnt/abstract/home/abstractinfo/.ssh/id_rsa
debug1: Server accepts key: pkalg ssh-rsa blen 247
debug1: read PEM private key done: type RSA
debug1: Authentication succeeded (publickey).
debug1: Final hpn_buffer_size = 131072
debug1: channel 0: new [client-session]
debug1: Entering interactive session.
debug1: Sending subsystem: sftp
sftp> lcd /mnt/abstract/home/abstractinfo
sftp> cd /home/abulhasi
sftp> mput a.sql
Uploading a.sql to /home/abulhasi/a.sql
sftp> ls -lrt
drwxr-xr-x 4 abulhasi abstractinfo 96 Oct 2 17:53 test.txt
-rw-r--r-- 1 abulhasi abstractinfo 11500 Oct 3 15:29 a.sql
sftp>
debug1: client_input_channel_req: channel 0 rtype exit-status reply 0
debug1: channel 0: free: client-session, nchannels 1
debug1: fd 0 clearing O_NONBLOCK
debug1: fd 1 clearing O_NONBLOCK
debug1: Transferred: stdin 0, stdout 0, stderr 0 bytes in 0.5 seconds
debug1: Bytes per second: stdin 0.0, stdout 0.0, stderr 0.0
debug1: Exit status 0
LOCAL>
---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

How To Unix:- Setting up client machines to connect by SSH/SFTP

2007-09-28T02:45:00.000+05:30

The steps to be followed:-
1/
genarate pub-priv key pair by using ssh-keygen command

#home/abulhasi $ ssh-keygen
Generating public/private rsa key pair.
Please be patient.... Key generation may take a few minutes
Enter file in which to save the key (/home/abulhasi/.ssh/id_rsa): HASIM_TEST
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in HASIM_TEST.
Your public key has been saved in HASIM_TEST.pub.
The key fingerprint is:
bd:43:bc:68:01:ee:c5:7e:fa:b7:5d:ef:a0:6f:ee:00 abulhasi@
#home/abulhasi $ ls -lart
total 42
-r-------- 1 abulhasi users 334 Jul 26 01:57 .login
-r-------- 1 abulhasi users 832 Jul 26 01:57 .cshrc
-r-------- 1 abulhasi users 347 Jul 26 01:57 .exrc
-r-------- 1 abulhasi users 446 Jul 26 01:57 .profile
drwxr-xr-x 324 root root 12288 Sep 23 09:50 ..
-rw------- 1 abulhasi users 0 Sep 27 14:59 .lastlogin
-rw------- 1 abulhasi users 1743 Sep 27 15:03 HASIM_TEST
drwxr-xr-x 2 abulhasi users 1024 Sep 27 15:03 .
-rw------- 1 abulhasi users 397 Sep 27 15:03 HASIM_TEST.pub
-rw------- 1 abulhasi users 354 Sep 27 15:04 .sh_history
#home/abulhasi $ pwd

A Private key looks like:-
#home/abulhasi $ cat HASIM_TEST
-----BEGIN RSA PRIVATE KEY-----
Proc-Type: 4,ENCRYPTED
DEK-Info: DES-EDE3-CBC,AB70B38F52800F59

aYUzVMyTp65/p824PMrFhGZ2IBWjRlJ+QnLeHCSW3qFJV/dg2LhYCSsBxOq6HNwf
+QAxgi/W5z299pgiy9EZtkI08gFVlOHtQaRbU//0I3Ifnn9zC8ncoY8OfTeDf1gJ
fH1VB3R2c+m/03GdsQ2Xsm00d+LnyGwCW1HQoFx+BWXBiC6p1avXtZwwEn+77oWu
BzOn4hrfebKZnt4k08Ej4ZuJ5mZqzQ820+1pF61aOEs8rZXt2HwlUP9KtPVWaP3i
iRHSctQuL3OSulpEpG94Mv3D4xR/64lla4GT9wOXpTXOjY9cT3BrIyGpOIFOrPvr
edMfkHZp7QLpZodEO9LBakh3p6if977PIXy1XJvpb2QR2wM94KUSSeouOhPvowma
KOg6M0aWF1UyT5EGb7UMcxXFEb7dgJ2STW2RUY21FDEGTIMDU7rEpU6l5kSwVgB1
y898XqgoN4gn9jv7l5jy0EjGcujyR2+OBYkxwFbeDpYb1ZFQxxwxqG0cdoRMqGQx
aI7KD1yRG4KVKmP9h1Q29k4zgmGQ3pX4Qd+r8jwTConAA52GdFRSaerqmW/SAwrA
5EU5rYvz86oVrl2QiD2fZ5ijgCH9Sm+iXzKbBsD1DsO6CnDeVjqC/YH+AQn+btJw
Zcc5Uz5PyrOJovVaLbh9YonopnFLiUHqa+fy35jAGGRqHVHTL6LEF3QDBCL8/iNn
jzjfF4KMMQx+SeXeVtAhDUV1pfOOMz8yhI+lKfrc4YxfMgot+gBD0nP5bLPMcswT
wmaBi+iJbDDTV+34JXH8I+/T5c13BQe+ATKMaXWk+RsnVgd4mfsqSM2uzkgeEE5w
6RiuLwt768hu7g2tw6NVex4ARO2R25TeiQue6cJUixp2CpWHshi7KIEFqXivta7s
kdNgX3WUlDf56p96v4mjwNibVPVjIFimEXw3V7H4Lch05WR5S2XmU/M8i92ZReju
AdSYy6dvMUJcvLauF2QWp8TvHQLN8oSv6s3ByE2nvV9Xj2aqGeqoBytDcLGWanbn
/fBWbfWUfIwkVGzaHYtFMde2yI78DCn2vk/bdNZxlqo7dF0Q1/O6jjcIcv6FlCFA
KXWetT/JkTpVxMxzx5zcBQ+XyuQd5KJ0To0/TxphXWFImDbs9ouK9GYmU2FZ/Vip
ujEcE7VB52IQiq/MgBGy6noKbwnPi/7pxM3iAMCKAHFw6kvuk7iMaJx0Vf6UTzNy
/ABHyTuEYusfteESLTr55wimpm0uM7q+FDvdtIH8FJMwbzW6Ni3QWB08yxIvBYkP
7yQupchLGxXUK68qmBCyNcHuStWj9ffgnxX/P1kOjUJbqpvwTC8cgf3cqCVy6QM6
a00kxx+cL8W7qRHe5jg8Ph9tNhBpA28pK8ycXevF/hmWBSdFHL9Ib/aX5w+rp8nh
CrP/NNChp5ZweoguNhRyULeZh0nVcMl0AZ+eyciIQLVxv0ZkUB99YeR/CD7xTL0z
GPFhxLeDYHP6DfwI4DlR0cDOsSnsp5vBtcyBVWtn0EJire+w8R4XgoZPC5sZaVWu
fpXc39+PTd2H5qcxxpCmconM+Y6kkiKhblsyar6rXKUcN55JZ4fxmQ==
-----END RSA PRIVATE KEY-----

A Public key looks like:-
#home/abulhasi $ cat HASIM_TEST.pub
ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEA1e+ftxpvHlDXdx/QccRkKAjukmLw6cNIQ0hiEWhUA3gCrYk7HdZdsT+Ag2mQpNoUZOV176R9b5FCpPvDjYX/7bL/Pflu23GsGTdDq78XyjCq9KJ/bboHRJxU8LJtuU3fRw9OashGLSfDLb6fTj22FnysyeD5sar24b3GGfrgistusqC2+DP99rtvrE8M046fc15H9KZ3TA8jHGZxJejcbj64lxjN9pKjRGUvxC8A42lVPe/ofBGP6kuP8xMau+rMXxB4FNVZchEwCXPTFls03ECdhnLrZ15EbD/E3AkqW5MiK/3JiQPGhAWXmItSiAPtspO7t0hQkaSbdyZXm6+0QQ== abulhasi@

2/

Send yours public key (HASIM_TEST.pub) to the remote server which is accepting ssh connection only.You can send them the key as a zipped file or by just copying and paste.
That remote server will add your publc key in the file ~/.ssh/authorized_keys.
3/
Once they have appended you can check it whether you can connect them or not by ssh -v remote_user@remote_machine
It may ask you for the passphrase whcih you have supplied at time of priv-pub key pair generation.
To get rid of entering passphrase you can add yours key in id_rsa by using ssh-agent :-
#home/abulhasi $ ssh-add id_dsa
Enter passphrase for id_dsa:
Identity added: id_dsa (id_dsa)
For more info check this page http://www.snailbook.com/faq/no-passphrase.auto.html

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

UNIX: How to tansfer a whole directory with all subdirectories by FTP

2007-08-08T00:51:00.000+05:30

That can not be done directly.But workaround is make a TARBALL and then FTP it.

To compress using tar
tar -cvf DestFile.tar SourceFile

To compress using compress

compress SourceFiles
By default all files will be compressd to SourceFiles.z

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

Informatica 7.1:HIER_28056

2007-08-02T03:07:00.000+05:30

HIER_28056 XML Reader: Error [PartialTagMarkupError] occurred while parsing.The input ended before all started tags were ended

Error:-READER_1_1_1> HIER_28056 XML Reader: Error [PartialTagMarkupError] occurred while parsing:[Error at (file /aaa/aaa/aaa/aaa/aaa/aaa.xml, line 2000, char 64 ): The input ended before all started tags were ended. Last tag started was 'dept'.]; line number [2000]; column number [64]

Reason:-This type of error may come
1/When FTP has not been done for that file from source and some corruption occurs

Solution:-Ensure FTP done properly.

HIER_28056 XML Reader: Error [NoGrammarResolver] occurred while parsing:An exception occurred! Type:UTFDataFormatException, Message:invalid byte 2 (`) of a 2-byte sequence..]

Error:-
HIER_28056 XML Reader: Error [NoGrammarResolver] occurred while parsing:[Error at (file /aaa/aaa/aaa/aaa.xml, line 1, char 39 ): An exception occurred! Type:UTFDataFormatException, Message:invalid byte 2 (`) of a 2-byte sequence..]; line number [1]; column number [39]

Reason:-Unsupported characters are there in teh xml file which are not supported by the encoding specified in the header.

Solution:-
1/Check for the character and the encoding.
2/If that character is apostrope then be alert about Midstream parser.Midstream parser does not allow apostrope.
3/If possible remove the charters from the xml file by editing it.
4/If needed change the encoding line to
5/If needed , edit the xml file and save it as UTF8.

HIER_28056 XML Reader: Error [NoGrammarResolver] occurred while parsing:The buffer manager cannot provide any more buffers.]

Error:-
HIER_28056 XML Reader: Error [NoGrammarResolver] occurred while parsing:[Error at (file /.../aaa.xml, line 10, char 56 ): An exception occurred! Type:RuntimeException, Message:The buffer manager cannot provide any more buffers.]; line number [10]; column number [56]

Reason:-
This is due to any component of that xml that has set as undefined length in the XML Source.And thats making the PowerCenter Server to consume a lot of memory to parse it.

Solution:-
1/Go to Designer-->Definition.
2/In XML Editor-->Search components in XML schema-->Advanced Options.
3/Go to Length Property. You will populate the infinite value.
4/Click on Search button to find out the matching components.
5/Change their length to some fixed value.
6/Save the mapping.

HIER_28060 XML Reader: Fatal Error:[The primary document entity could not be opened

Error:-
HIER_28060 XML Reader: Fatal Error:[The primary document entity could not be opened. Id=e:\demo\SrcFiles\data.xml]

Resolution:-
Edit the task of the worflow and check for the path of your file.

HIER_28056 XML Reader: Error [NoGrammarResolver] occurred while parsing:Could not open DTD

Error:-
HIER_28056 XML Reader: Error [NoGrammarResolver] occurred while parsing:[Error at (file e:\demo\SrcFiles\note_ex_dtd.xml, line 2, char 34 ): An exception occurred! Type:RuntimeException, Message:Could not open DTD file 'e:\demo\SrcFiles\note.dtd'.]; line number [2]; column number [34]

Resolution:-
Check in the same location your xml file is.Is there there dtd also?

HIER_28056 XML Reader: Error [UnterminatedEntityDecl] occurred while parsing:Expected a markup declaration

Error:-
READER_1_1_1> HIER_28056 XML Reader: Error [UnterminatedEntityDecl] occurred while parsing:[Error at (file e:\demo\SrcFiles\note.dtd, line 1, char 3 ): Expected a markup declaration.]; line number [1]; column number [3]

Resolution:-
Edit your dtd file in xmlspy and remove all unwanted lines/words from begining/end.

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

PICTOGRAPHY

2007-06-11T12:33:00.006+05:30

A picture is worth a thousand words

Informatica7.1:HIER_28004 XML Reader Error:Could not retrieve a block from the DTM

2007-05-20T16:08:00.000+05:30

We use to load almost 2-3 millions data from XML per day.Nowadays we were getting a strange kind of error as in the title.
We have our mechanism which can remove the error HIER_28056.But that mecanism can not solve this error.So many files were failing.I identified that it was happening due to smaller buffer size.I increasec the DTM size and its solved.

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

US gun culture

2007-05-02T02:36:00.000+05:30

Couple of weeks before there was an incident in Virginia Tech.One South Korean chap open fired in VT campus and killed several students and teachers.The discussion of that shocking incident is still in the air.Being a new comer here I got shocked hearing that its permissble for you to keep gun.In india its not permissible and as per my knowledge except Phillipines its evrywher not permissble in Asia.And you can buy gun and firearms easily if you are older that 21.

And peoples have different views of keeping gun or not.Obviously for the weak hearted,peace loving Software engineers its always not keeping gun but theres a large community to support gun also.
They have two big organisation also NRA and community of gun owners
I heard many debates.

LOGICS of GUN LOVING PEOPLES:-

-To keep their life safe they use gun.
-If miscreants know that they have gun they will dare to attack.
and many more.
check for the brain washers by them
here

LOGICS of PEPOLES AGAINST GUN:-

-You may kill yourself by your gun while you in mental depression.
-A hot tempered people may kill others at the heat of the moment.
-Dont compare the no of death by gun with no of death in car accident et all.Can both be termed as accident always?car accident is always an accident.Whats about gun death?

CONCLUSION:-(Not by me)
The concusion which seems true to me from ASIA SENTINEL
"US gun laws gave Cho Seung-hui (the killer in VT ) the firepower to commit his carnage...
Cho pulled the trigger but America put the gun in his hands."
---: I am not responsible for any damages happened from the suggestion of my blog :--- Reach me at : m.a.hasim@inbox.com

Informatica7.1:What is version control in Informatica7.1

2007-05-01T00:04:00.001+05:30

Version Control is a new enhancement in 7.1
It means that you can go back to any of the previous development phase of a mapping or session.

Whenver you are developing a mapping/session it will be in check out mode by itself untill explicitly you have not checked it out.

Some points to remember:-

Version controlling option you need to specify at the time of creation or later.
But once you have choosed you can not revert back yours repository at non-version mode.
---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

The Great Mall In Milipitas

2007-04-29T12:06:00.000+05:30

Today we went for shopping at Great Mall in Milipitas.Miliptitas is 40 mins distance from Sunnyvale towards San Jose.Literally Milipitas means "Little Cornfield".This was mainly a farmland earlier.And its now also a part of GREATER SILICON VALLEY.

The Way towards milipitas

The Mall is one of the largest mall in bay area.In fact its the largest mall in Northern California.Its although having ground floor but having a vaaast area under its roof.Many outlets are there-Dockers,Gap,Ray-Ban,Kohl,Sears,Food court etc.Its has a 60 screen theatre also.

View of Red Court

Green Court

Typical walkway

Yellow Court And Food Court
What we bought...?
Nothing...:P

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

My First Jummah in USA

2007-04-28T13:31:00.000+05:30

Today I went for namaz.Saw the mosque in USA.Its in Santa Clara.Near to Sunnyvale but far from my office Palo Alto.Afzal bhai came to pick me up from office and then we went there.Already so many cars were there.We had to park our car too far from mosque as the parking slots for the mosque has been filled.Its really a big mosque.Earlier it was also an HP Office.Now has been transferred to be used as a mosque.It has all most modern amenities.Ladies and gents can pray simultaneously.There two jummah prayer happens in friday due to heavy rush.Most the peoples are from software sector-from Yahoo,Sun,CISCO,HP et all.The mosque also has library,islamic book and amenities shop.Board room for the pepoles who are new to Islam or for them who wants to know Islam more.Also they used to organise various activities.There is a school for kids attached with the mosque.
Can know more HERE

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

Sunny Days in Sunnyvale....

2007-04-27T03:33:00.000+05:30

The concept of city is different here than India.here cities has average area of atmost 100 sq mile.
That is some how 1/4th to 1/5th of big cities like Delhi,Kolkata.

And here cities are adjacent to each other.Like as we have our office in Palo Alto and while going office we start from Sunnyvale,cross another city Mountain View and then comes Palo Alto.

All the three cities comes under Silicon valley.
When we say silicon valley mostly those cities comes under this umbrella.
* Campbell
* Cupertino
* East Palo Alto
* Fremont
* Gilroy
* Los Altos
* Los Altos Hills
* Los Gatos
* Menlo Park
* Morgan Hill
* Mountain View
* Milpitas
* Palo Alto
* Redwood City [2]
* San Jose
* Santa Clara
* Saratoga
* Sunnyvale
Here almost 1000 Fortune companies has their head quarter.

In all bay area there are a lots of indians,pakis or chinese.Lots of South Asian resturants also.You will never feel away from home or other way you will never get the full charm of America.

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

Informatica7.1: Sequence genarator Overflow Error

2007-04-26T03:20:00.000+05:30

Error Message:
TRANSF_1_1_1> TT_11009 Sequence Generator Transformation: Overflow error.
TRANSF_1_1_1> Wed Apr 25 09:26:17 2007
TRANSF_1_1_1> TM_6085 The transformation [SQ_Shortcut_To_CUSTOMERADDRESS] encountered fatal error. Terminating session.
TRANSF_1_1_1> TT_11009 Sequence Generator Transformation: Overflow error.

Solution:-
Check that sequence transformation.then Enable cycle/Reset the start-end value.

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

Tour2US...1

2007-04-24T11:54:00.000+05:30

We have reached there by Cathay Pacific...Its somehow good airlines in comparison to the other.I dint have the aothority to compare but heard from the seniors who have flied by china airlines,malaysiaa airlines or other.But they concluded that British Airlines is the best.Anyway,I have enjoyed the whole flight.It served all asian foods and liquors.But as dont have that habit I gulped fruit juice and wathed movie in the whole flight.

We reached San Frncisco International Airport at about 1.00 pm local time.The view of the bay area from the flight is superb.The silicon valley is surrounded by mountains from both side like adring the sea by two hands.

We have taken shuttle (this is a kind of shared car ).In this we were four-me,naveen,satosh( a guy of wipro-blore and another guy...i am forgetting his name).

Hotel was booked already in Town House Inn in El Camino Real.Here we met Gerald and Sandeep.Gerald was known to me through Parthiban but Sandeep was unknown.
---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

Given Name,I 94 and me...

2007-04-20T06:29:00.000+05:30

After mar12....now i am posting another...a longgg gap...in this meantime,i came US...i got so much problem due to my non-seriousness...I made mistake in my I-94 and then headache started...I did not get my SSN...I could not make my DMV and et all....I swapped my last name and my given name in that small lil form given to my in the flight towards San Francisco...That time i never thought this small form will make my life hell...I went to local Social Security office...They sent me to USCIS,San Jose...and then they sent me to San Francisco USCIS...Its a big problem without a car to move in US...Today just coming back from San Francisco...Thanks GOD...My name has bene rectified...I also made mess with my name everywhere...In Bank account...In office forms...where not?
Ultimately people started making fun of that....
--"Hey Hasim...wats ur last name and wats ur given name..."
--"Come on mannn...Every letters of my name is given to me....Err..may be mom...I was a kid then ..How can I..."I used to reply them amusingly...
---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

Informatica 7.1: pmcmd can not connect to the server

2007-03-12T19:43:00.000+05:30

Error:-

"The connect request failed because it wanted to connect to a server of type pmserver" using pmcmd...."

Solution:-

Its asking for Informatica Server Port no.Not of the repository server.check for the specific port no from workflow manager-->server configuration if you dont know it.
---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

UNIX :How to search a string inside a zipped file in unix?

2007-03-08T15:21:00.000+05:30

By using zcat.
$ zcat myfile.030807000455.log.gz|grep -i error
ERROR at line 4:

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

PLSQL:Can we CREATE a VIEW FROM a non-existed TABLE?

2007-03-06T16:31:00.000+05:30

Yes.BY FORCE VIEW.

CREATE VIEW tmp_view AS SELECT * FROM empwer
--ORA-00942: table or view does not exist ( as empwer table does not exist )
CREATE FORCE VIEW tmp_view AS SELECT * FROM empwer
--Create view, executed in 0.375 sec. ( Force view created )
SELECT * FROM tmp_view
--ORA-04063: view "SCOTT.TMP_VIEW" has errors ( As there is no underlying table )
CREATE TABLE empwer AS SELECT * FROM emp
--CREATE TABLE empwer AS SELECT * FROM emp ( Underlying table created )
SELECT * FROM tmp_view
--Results Coming ( Now data is coming through view )

-----CleanUp-------
DROP TABLE empwer
DROP VIEW tmp_emp

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

DTS:-Problem in Renaming Transform Data Task

2007-02-01T18:29:00.000+05:30

Problem:-
We had a transform data task in our package which we used to refer through a ActiveX script.
Later we have deleted that task and again created one in the same place having the same funtionality.But when we have created the new one the ActiveX started throwing error that it couldnot find a particular step.

Solution:-
We have renamed the step.
>> Disconnected Edit.
>> Went to the step.
>> Renamed it.

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

SQL SERVER: How can we find whether a table is existing in our database or not?

2007-02-01T13:02:00.001+05:30

Use pubs
select * from information_schema.tables -- to get details about all tables.
select * from information_schema.columns -- to get columns of all tables.

Most of the DBA level info can be extracted from information_schema views.
Some more format:-
View Name Description
CHECK_CONSTRAINTS Holds information about constraints in the database
COLUMN_DOMAIN_USAGE Identifies which columns in which tables are user-defined datatypes
COLUMN_PRIVILEGES Has one row for each column level permission granted to or by the current user
COLUMNS Lists one row for each column in each table or view in the database
CONSTRAINT_COLUMN_USAGE Lists one row for each column that has a constraint defined on it
CONSTRAINT_TABLE_USAGE Lists one row for each table that has a constraint defined on it
DOMAIN_CONSTRAINTS Lists the user-defined datatypes that have rules bound to them
DOMAINS Lists the user-defined datatypes
KEY_COLUMN_USAGE Lists one row for each column that's defined as a key
PARAMETERS Lists one row for each parameter in a stored procedure or user-defined function
REFERENTIAL_CONSTRAINTS Lists one row for each foreign constraint
ROUTINES Lists one row for each stored procedure or user-defined function
ROUTINE_COLUMNS Contains one row for each column returned by any table-valued functions
SCHEMATA Contains one row for each database
TABLE_CONSTRAINTS Lists one row for each constraint defined in the current database
TABLE_PRIVILEGES Has one row for each table level permission granted to or by the current user
TABLES Lists one row for each table or view in the current database
VIEW_COLUMN_USAGE Lists one row for each column in a view including the base table of the column where possible
VIEW_TABLE_USAGE Lists one row for each table used in a view
VIEWS Lists one row for each view

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

SQL SERVER:-WHAT IS THE DIFFERENCE BETWEEN ISQL AND OSQL

2007-01-31T20:51:00.000+05:30

Both are command prompt utilities but as per HELP:-

The isql utility allows you to enter Transact-SQL statements, system procedures, and script files; and uses DB-Library to communicate with Microsoft® SQL Server™ 2000.

And

The osql utility allows you to enter Transact-SQL statements, system procedures, and script files. This utility uses ODBC to communicate with the server.

Use OSQL whenever possible as it supports UNICODE which ISQL doesnt.
---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

SQL SERVER:HOW TO RUN A SQL SCRIPT WHICH IS IN YOUR LOCAL DRIVE?

2007-01-31T20:44:00.000+05:30

a/
Create a file in C:\ drive Hasim.sql is as follows:-

SELECT t1.empname [Employee], COALESCE(t2.empname, 'No manager') [Manager] FROM emp t1 LEFT OUTER JOIN emp t2 ON t1.mgrid = t2.empid;

b/
Create a table emp in tempdb

use tempdb;

CREATE TABLE emp
(
empid int,
mgrid int,
empname char(10)
);

c/
Populate the table

INSERT emp SELECT 1,2,'Hasim'
INSERT emp SELECT 2,3,'Arun'
INSERT emp SELECT 3,NULL,'Divya'
INSERT emp SELECT 4,2,'Parthiban'
INSERT emp SELECT 5,2,'Priyanka'

d/
Run that sql file in C:\ drive as follows:-

EXEC master..xp_cmdshell 'isql -SAHASIM -Usa -Psa -ic:\Hasim.sql -n'

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

SQL SERVER: Maximum number of columns per table

2007-01-31T20:16:00.000+05:30

Ans:-
========
1,024

Interested to find out maximum number of columns possible in a select statement et all?
Check the MSDN page:-
Maximum Capacity Specifications

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

SQL SERVER: What is CHECKSUM

2007-01-31T20:00:00.000+05:30

FROM HELP FILE

CHECKSUM computes a hash value, called the checksum, over its list of arguments. The hash value is intended for use in building hash indices. If the arguments to CHECKSUM are columns, and an index is built over the computed CHECKSUM value, the result is a hash index, which can be used for equality searches over the columns.

We can easily detect if there is a changes in any rows in any places ( in any particular fields)

-----------Example---------

use pubs

SELECT au_id , au_lname ,
CHECKSUM ( au_id , au_lname ) AS chk
FROM authors

--409-56-7008 Bennet 271639220

update authors set au_lname = 'Bennet' where au_id = '409-56-7008'

SELECT au_id , au_lname ,
CHECKSUM ( au_id , au_lname ) AS chk
FROM authors

--409-56-7008 Bennet 271639220( No changes in checksum )

update authors set au_lname = 'Bennnet' where au_id = '409-56-7008'
SELECT au_id , au_lname ,
CHECKSUM ( au_id , au_lname ) AS chk
FROM authors
--409-56-7008 Bennnet -1628839244( Checksum changed )

update authors set au_lname = 'Bennet' where au_id = '409-56-7008'
SELECT au_id , au_lname ,
CHECKSUM ( au_id , au_lname ) AS chk
FROM authors
--409-56-7008 Bennet 271639220 ( Again the check sum is the same )

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

Unix:How to know the code page of your HP UX

2007-01-25T14:23:00.000+05:30

Most UNIX system has more than one code page installed.But they may use US-ASCII code page by default.You can change code page by changing the variable as LC_CTYPE,LC_ALL and LANG_C.

Now the code page seen in my HP UX is as follows:-

$ locale
LANG=
LC_CTYPE="C"
LC_COLLATE="C"
LC_MONETARY="C"
LC_NUMERIC="C"
LC_TIME="C"
LC_MESSAGES="C"
LC_ALL=
** Here "C" means ASCII

To change the language to English and making the system to use Latin1( ISO 8859-1):-
$ setenv LANG en_US.iso88591
$locale
LANG=
LC_CTYPE="en_US.iso88591"
LC_COLLATE="en_US.iso88591"
LC_MONETARY="en_US.iso88591"
LC_NUMERIC="en_US.iso88591"
LC_TIME="en_US.iso88591"
LC_MESSAGES="en_US.iso88591"
LC_ALL="en_US.iso88591"

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

Informatica 7.1: Can we use Excel as target?

2007-01-24T19:50:00.000+05:30

In case of UNIX machine neither you can make Excel as source or target as there is no ODBC driver there in UNIX for this purpose.But,in case of windows you can make Excel as source but not as target.

Workaround:-
*** Contributed By Mr. Nitant Mahajan ***
1/
In workflow manager.
Set file properties-->keep delimeter as CSV-->Optional Quotes Double
* If your data do not contain COMMA then only COMMA delimer will solve the purpose *
File should be saved into .csv format.

2/
Set the delimeter as TAB and save file as .xls

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

Informatica 7.1:Can we install two instances of INFA 7.1 into the same HP UX machine?

2007-01-24T13:44:00.000+05:30

No for windows installation as in that case the new installation will delete the earlier services.

Yes for UNIX.But:-
1/
In that case the installation should must be done under different users account.
2/
Use different ports.

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

HowTo: How to run sqlplus queries on the fly?

2007-01-23T19:31:00.000+05:30

Generally in shell script we use to invoke sqlplus passing some sql script like as follows:-
---------Sample.sql--------------------
select sysdate from dual;
---------------------------------------
---------Script1.sh--------------------
echo "Starting the script"
sqlplus scott/tiger@orcl @sample.sql
echo "Finishing the script"
---------------------------------------
Now you can run that query on the fly like as follows:-

$pwd
/mnt/hasim/home
$print "select sysdate from dual;"|sqlplus scott/tiger@orcl

Or
---------Script2.sh--------------------
echo "Starting the script"
sqlplus scott/tiger@orcl"<<"EOF # Remove both quotes,put due to error while posting
select sysdate from dual; -- Write n no of sql scripts
EOF
echo "Finishing the script"
---------------------------------------

Can check more in this page
How do I interact with Oracle via the UNIX Korn shell?

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

Informatica 7.1:./install: pmeval: Execute permission denied.

2007-01-23T16:32:00.000+05:30

One of my friend has faced this problem:-
$ pwd
/home/XXXX/informatica_install/PowerCenter/ipf64
$ cd /home/XXXX/informatica_install/PowerCenter
$ chmod 777 ipf64
$ cd /home/XXXX/informatica_install/PowerCenter/ipf64
$ ./install
Please choose the language to run install in from the choices below:
1. English
2. Japanese
0. Exit
> 1
===================================================
Welcome to Informatica Installation Wizard.
All Informatica Products Copyright 1996-2007.
===================================================
Please enter your Product Key for Informatica PowerCenter: /home/XXXX/informatica_install/PowerCenter/ipf64
./install: pmeval: Execute permission denied.
grep: can't open /tmp/tkf.22131
grep: can't open /tmp/tkf.22131
grep: can't open /tmp/tkf.22131
The key you entered is key. Please enter the product license key.

Solution:-
This problem occurs when we try to enter wrong product key ( need to enter 64bit Product key instead of 32 bit product key )
Once proper key is set,things will be smooth.
HOW TO FIND YOUR UNIX IS 32bit or 64 bit

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

Informatica 7.1:Points to ponder while transferring data from

2007-01-23T16:06:00.000+05:30

The problem I got like:

The source data is 88591 we use ETL informatica it is having 11 charcter set of data since 88591 is 1 byte of data it gives samecode for different charcterset for example it is having x(code)=man(japan),women(korean) it raises ambiguity in database for japan and korean language , and now at present target is also 88591 the same "x" is sent to target but here there own languge is set in their system , if koren guy sees it he will undersatnd it is women and if japan guy sees he will understand as man but now we are going to make target database into utf-8 and informatica run in unicode mode here the source system is in 88591 as i have told u earlier it may generate same code for some charcterset now when we load it into target which is utf-8 here it generates unique code for different charcterset but we need to identify the end user reqirement and give him yhe exact data.

example
If end user is korean in earlier case it is x but now utf-8 generates unique code so we need to tell to informatca before loading in to target there it supports all charcaterset and give unique code for each charcter set.

My intention:-
==============
We will be deciding at the time of running sessions or one time conversion yo flat file to utf-8 and then to target.

Although I know problem may seem hazy.Lets make it a lil bit clear before putting the solution.

A database named ABCD is defined to only support one character set(ISO-8859-1), data is getting populated here with data from multiple character sets like sjis,big5, GB2312 etc. We accept that the ordering of the data is according to ISO-8859/1

Slowly as time passes by ABCD will have text data in multiple different languages in multiple different character sets and later it becomes tough for identifying which language and character set the text belongs to. The UTF8 encoding of UNICODE, which keeps any current text in USASCII unchanged (the vast majority of our text data), but stores data from other character sets in 2, 3, or 4 byte units.

Now there is a requiremwnt to transfer data from ABCD toanother database named EFGH which is in UNICODE.So we need to be able to identify the character set of every text string.Lets assume we have identified that also.

Question is that how to perform that data transfer through INFA7.1

Solution:-
Thats can be done by INFA.Just keep following things in mind.

1/
Check what is the type of your source database character set ( select * from nls_database_parameters ) 2/ Check what is the type of your target database character set( select * from nls_database_parameters ) 3/ Check what data movement has been set for Informatica Server which you are to assign in your workflow.
( Go to the config file you use to pass while starting informatica server in UNIX )

Eg.
# Determine one of the two server data movement modes: UNICODE or ASCII.
# If not specified, ASCII data movement mode is assumed.
# ASCII:-PowerServer processes single byte character and does not perform codepage #conversion
#UNICODE:-Processes 2 bytes for a character.Enforce codepage validation

DataMovementMode=Unicode
/*************************************************************************************************
Set it Unicode,only then the end users will have full data else while there will be corrupt data.
If you are resetting,after resetting restart the Informatica Server service.
*************************************************************************************************/
4/
If you have set all those things right,then there is nothing to worry.Users should must see Data as per their locale.
5/
You may face some LM_ error while loading data through INFA.In that case revert me back with error log portion like
/*************************************************************************************************
MAPPING> CMN_1569 Server Mode: [UNICODE] CMN_1570 Server Codepage: [ISO
MAPPING> 8859-1 Western European]
*************************************************************************************************/
6/
If needed then disable codepage validation.

Some More pages I have referred while going through this.Mainly pages related to Oracle database.They are as follows:-
i/
A very basic knowledge about oracle character set conversion.
*** DONT ALTER YOUR DATABSE EVER TO SEE CHINESE CHARACTER - THEN YOUR DBA MAY SEND YOU TO CHINA ***
Exzilla

NLS_LANG FAQ From Oracle - Very Good One.
NLS_FAQ
HOW TO CHECK WHAT IS THE CODEPAGE FOR YOUR HPUX
---: I am not responsible for any damages happened from the suggestion of my blog :---

Reach me at : m.a.hasim@inbox.com

How to know whether my Oracle is 32 bit or 64 bit? My Unix OS is 64 bit or not?

2007-01-23T16:02:00.001+05:30

Check out this page:-
Oracle Advice

In my case:-
SQL> select address from v$sql where rownum <3;

ADDRESS
----------------
C000000089B2A230
C0000000897F8D00
Means oracle was 64 bit.

And Unix is 64bit also:-
$ getconf KERNEL_BITS
64

To check Unix/Linux OS version:-
$ uname -a
Linux abulhasim.fun.com 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:54:53 EST 2006 i686 i686 i386 GNU/Linux

Check this page:-
http://forums13.itrc.hp.com/service/forums/questionanswer.do?admit=109447627+1227684096982+28353475&threadId=1150062

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

SSIS v9.x:How To Pass Parameters At Runtime in dtexec

2007-01-19T18:24:00.000+05:30

HOW TO SET VALUE AT RUNTIME
===================================
1/
Create a simple package having such data flow.

2/
Create a package level variable staying in package explorer tab as follows

3/
Set that varaible as your connection string for the source flat file as follows:

4/
Create configuration file from SSIS-->Package Configurations-->Add-->Etc-->Etc.
It will make a xml file.
5/
Run it from command prompt.
dtexec -f Flat2DB_configAtRunTime.dtsx
This time it will get that there is a parameter which bears the value for the sorce file`s connection string and after searching through the config file in the same directory as the package it will get the value of that parameter at runtime from the element named "ConfiguredValue".
Now wat if we want to pass the value at run time?Yes,that can be done also.To do so first change the config file`s "ConfiguredValue" to some unknown value so that you can be sure that what value you are tio pass at runtime works.And then run at command prompt.
dtexec -f Flat2DB_configAtRunTime.dtsx /Set \Package.Variables[User::MyVar].Properties[Value];"C:\Documents and Settings\Hasim\My Documents\TEST\SSIS\emp1.txt"
---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

SSIS v9.x:Error codes

2007-01-19T13:28:00.000+05:30

This page gives you all details about the error codes in Hex as well as in Dec
MSDN:Integration Services Error and Message Reference
---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

Informatica 7.1: XSD and XML file for SCOTT Emp table.My first mapping in xml

2007-01-12T17:03:00.000+05:30

1/
As a xml editor I used Stylus .
By this you can get data into xml file from EMP table.
File-->New-->DB to XML Datasource.
Connect to the databse.Select EMP table and get data as xml.

The stylus will run this following query
SELECT
XMLELEMENT(name "row",
XMLELEMENT(name "EMPNO",t.EMPNO),
XMLELEMENT(name "ENAME",t.ENAME),
XMLELEMENT(name "JOB",t.JOB),
XMLELEMENT(name "MGR",t.MGR),
XMLELEMENT(name "HIREDATE",t.HIREDATE),
XMLELEMENT(name "SAL",t.SAL),
XMLELEMENT(name "COMM",t.COMM),
XMLELEMENT(name "DEPTNO",t.DEPTNO)
)
FROM EMP t

to get data in XML.

The file is DOWNLOAD EMP XML FILE

2/
Create a schema for that emp.xml as XML-->Create Schema from XML content.
You can create a XSD or DTD ( internal/external)
DOWNLOAD EMP EXTERNAL DTD
DOWNLOAD EMP XML WITH INTERNAL DTD
DOWNLOAD EMP XSD

3/
Use that EMP XSD to create XML view.Tools-->Source Analyzer-->Import XML Defination.

4/
Develop necessary transformation and flow data.

POINTS TO PONDER:
=================

0>> Check in Workflow Manager for the path for source XML.
0>> Apply transformation if there is a need for data conversion.

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

Informatica 7.1: XML file as Source

2007-01-10T20:35:00.000+05:30

What is a DTD

A DTD file contains metadata only.It contains the structure and the definitions of the elements and attributes which can be found in the main xml.

What is a XSD
Good basic tutorial is in W3Schools:-Introduction to XML Schema
XML namespace identifies a group of similar kind of elements belongs together.

What is the basic difference between XSD and DTD?

* DTD's are not namespace aware.

DTD's have #define, #include, and #ifdef -- or, less C-oriented,
the ability to define shorthand abbreviations, external content,
and some conditional parsing.

A DTD describes the entire XML document (even if it leaves "holes");
a schema can define portions.

XSD has a type system.

XSD has a much richer language for describing what element or attribute
content "looks like." This is related to the type system.

You can put a DTD inline into an XML document, you cannot do this with
XSD. This means DTD's are more secure (you only have to protect one
bytestream -- the xml/dtd -- and not multiple).

The official definition of "valid XML" requires a DTD. Since this may
be impractical, if not impossible, you often have to settle for
schema-valid, which is not quite the same.

In terms of validation functionality, XSD can define all the constraints that a DTD can define, and many more. To take a simple example, XSD can say that a particular attribute must be a valid date, or a number, or a list of URIs, or a string that is exactly 8 characters long. To take another example, XSD can define much richer constraints on uniqueness of values within a document.So
XSD provides much more control over the XML then DTD.

Can we supply a XML file having no XSD or DTD associated with it as source?

- Yes.In that case designer will read the tags for the elements,reads each element to determine their datatype and precision,their possible occurences and their position in the hierarchy.

* Mapping designer can create source qualifier from XSD/DTD supplied with the XML file.
* But this determining takes long time if the source XML is large.So its always better to have a XSD or DTD ( internal/external ) associated with that XML.
* Mapping designer can be configured to validate the input XML file as per as the supplied XSD or DTD.

What does "sequence" mean in a complex type XSD?

XSD can be of two types:-
o> Simple type XSD: Having one element inside it only.
Check XSD Simple Elements
o> Complex type XSD: Having more than one element inside that.
Check XSD Complex Elements

Whatever elements have been described inside sequence they should be in the same order in the XML file.

Check the example Check the person element

Sequence is one kind of indicator to tell the XML file how it should have elements in it,in which sequences,how many times a element may occur,are the elements/atrtributes going to appear in the XML as a group or not.

Check XSD Complex Types Indicators

What do you mean by "element type any"?

The "anyAttribute" element enables us to extend the XML document with attributes not specified by the schema.

In that case the XML file may get some more attributes from other XSD except the main XSD associated with it.

Check an example from Wschools
anyAttribute

What is pivoting in INFA?

Sometimes in the source XML we have mulitiple occurence of same elements.Like as in customer.xml file there may be two sets of address for each customer;one for home address another for office address.So in that case we wish to have two different channels towards our target in mapping.So we do pivoting in that case.

---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com

Informatica 7.1:Error LM_36526:signal 6- Unexpected Condition Detected

2007-01-10T18:39:00.000+05:30

PROBLEM

Sometimes unexpectedly session terminates contained mapping having router in it.The error is:
LM_36526:signal 6- Unexpected Condition Detected

Warning: Unexpcted condition at: widgfld.cpp: 11

ERROR : LM_36526 [Wed May 11 15:12:40 2005] : (29532|36) Session task instance [s_Some_session]: DTM process [pid = 14102] exited due to signal [6].

SOLUTION

1/
Take the backup of INFA metadata.

2/
Run the following query on INFA metadata and check for results:

SELECT A.SUBJ_NAME ,B.MAPPING_NAME ,C.WIDGET_ID ,C.INSTANCE_NAME
FROM OPB_SUBJECT A ,OPB_MAPPING B ,OPB_WIDGET_INST C
WHERE A.SUBJ_ID=B.SUBJECT_ID AND B.MAPPING_ID =C.MAPPING_ID AND B.VERSION_NUMBER = C.VERSION_NUMBER AND C.WIDGET_TYPE=15 AND B.IS_VISIBLE > 0 AND C.WIDGET_ID IN
(select w.WIDGET_ID from opb_widget_field wf, opb_widget w
where w.widget_type = 15 and w.widget_id = wf.widget_id and w.version_number = wf.version_number and w.is_visible > 0
and wf.widget_fld_prop = 0 and wf.porttype = 2)

3/
If the query returns more than one row then...

4/
CREATE TABLE OPB_WIDGET_FIELD_BCKUP AS SELECT * FORM OPB_WIDGET_FIELD; --Taking bkup

5/
update opb_widget_field set widget_fld_prop =
(select f2.field_id from opb_widget_field f2, opb_widget w
where f2.widget_id = opb_widget_field.widget_id and f2.version_number = opb_widget_field.version_number and f2.widget_id = w.widget_id and f2.version_number = w.version_number and w.is_visible > 0 and w.widget_type = 15 and f2.field_name =
substr(opb_widget_field.field_name,1,length(opb_widget_field.field_name)-1))
where widget_fld_prop=0 and porttype = 2 and exists (select * from opb_widget w where w.widget_type = 15 and w.is_visible > 0 and w.widget_id = opb_widget_field.widget_id and w.version_number = opb_widget_field.version_number)

6/
Run the problematic session again.

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

Informatica 7.1:Core dump

2007-01-09T20:56:00.002+05:30

Sometimes we may get core file into INFA server directory due to unexpected behaviour of INFA processes.

Coredump may occur due to:-
1/ In a KSH you are instructing to run a script in SH.
2/ From 7.1x client you trying to access/execute session of another version (8.x).
3/ the machine where pmserver reside is having less RAM.

Core dump files generally created by the kernel when a specific process tries to access a memory area which is not specified for that by the kernel.

How to debug
1/
$ file core
core: core file from 'pmdtm'
$ adb pmdtm core
adb: warning: Cannot locate unwind table ...
adb: warning: Stack backtrace may fail.
adb> $c
_raise + 0x24
_abort_C + 0x160
abort + 0x1c
Alloca Error: Cannot unwind alloca frame. (UNWIND)
adb> $q
$

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

Informatica 7.1:How to upgrade INFA from 7.1 to 8.1

2007-01-08T19:46:00.000+05:30

We are to upgrade our INFA from 7.1 to 8.1.

We have chalked out the strategey as follows:

1/
At first we need to back up of our repository by using backup command in pmrep which syntax:

backup
-o #output file name#
-f (overwrite existing output file)
-d #description#
[-b (skip workflow/session logs)]
[-j (skip deploy group history)]
[-q (skip MX data)]

2/
Then to copy the old repository into the new location without copying the content.

3/
Install upgraded version client and server.

4/
From Administration Console create and select Repository Service.
Be alert for database type,cennection info and codepage-->Do not create repository content-->Create
Check all if u are sure-->Enable-->Actions-->Upgrade Contents.
Check for the contents once again.

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

Informatica 7.1: All available tasks can be done by pmrep

2007-01-08T19:04:00.000+05:30

run
-f #script file name#
[-o #output file name#]
[-e #echo commands#]
[-s #stop at first error#]

connect
-r #repository name#
-n #repository user name#
[-x #repository password# |
-X #repository password environment variable#]
-h #repserver host name#
-o #repserver port number#

backup
-o #output file name#
-f (overwrite existing output file)
-d #description#
[-b (skip workflow/session logs)]
[-j (skip deploy group history)]
[-q (skip MX data)]

updatestatistics

updateemailaddr
-d #folder name#
-s #session name#
-u #success email address#
-f #failure email address#

updatesrvvar
-s #server name#
-v #variable name#
-u #new value#

updatetargprefix
-f #folder name#
-s [#qualifying path#.]#session name#
[-t #target name#]
-p #prefix name#
-n

updatesrcprefix
-f #folder name#
-s [#qualifying path#.]#session name#
[-t #source name#]
-p #prefix name#
-n

updateseqgenvals
-f #folder name#
[-m #mapping name#]
-t #sequence generator name#
[-s #start value#]
[-e #end value#]
[-i #increment by#]
[-c #current value#]

listobjects
-o #object type#
[-t #object subtype#]
[-f #folder name#]
[-c #column separator#]
[-r #end-of-record indicator#]
[-l #end-of-listing indicator#]
[-b #verbose#]

listtablesbysess
-f #folder name#
-s [#qualifying path#.]#session name#
-t #source or target#

listallusers

listallgroups

createuser
-u #repository user name#
[{-p #password#
-c #password again#} |
-P #password environment variable#]
[-d #description#]
[-g #group name#]
[-i #contact info# ] }

registeruser
-u #repository user name#
-l #external login#
[-d #description#]
[-g #group name#]
[-i #contact info# ] }

rmuser
-u #repository user name#

changepasswd
[{-p #new password#
-c #password again#} |
-P #new password environment variable#]

edituser
-u #repository user name#
[{-p #new password#
-c #password again#} |
-P #new password environment variable#]
[ -l #new login# ]
[ -d #new description# ]
[ -e #enabled: yes|no# ]
[ -i #contact info# ]

addusertogroup
-u #repository user name#
-g #group name#

rmuserfromgroup
-u #repository user name#
-g #group name#

creategroup
-g #group name#
[-d #description#]

rmgroup
-g #group name#

listallprivileges

addprivilege
-p #privilege#
{ [-u #repository user name#]
[-g #group name#] }

rmprivilege
-p #privilege#
{ [-u #repository user name#]
[-g #group name#] }

createconnection
-s #relational connection subtype#
-n #connection name#
-u #user name#
[-p #password# |
-P #password environment variable#]
[-c (connect string, required for Oracle, Informix, Db2 and ODBC)]
-l #code page#
[-r (Rollback Segment, valid for Oracle connection only)]
[-e (Environment SQL)]
[-z (Packet Size, valid for Sybase and MS SQL Server connection)]
[-b (Database Name, valid for Sybase, Teradata and MS SQL Server connection)]
[-v (Server Name, valid for Sybase and MS SQL Server connection)]
[-d (Domain Name, valid for MS SQL Server connection only)]
[-t (1 for Trusted Connection, valid for MS SQL Server connection only)]
[-a (Data Source Name, valid for Teradata connection only)]

switchconnection
-o #old connection name#
-n #new connection name#

deleteconnection
-n #relational connection name#
[-f (force delete)]

showconnectioninfo

updateconnection
-t #database type#
-d #database connection name#
-u #new user name#
[-p #new database password# |
-P #new database password environment variable#]
-c #new database connection string#

updateserver
-v #server name#
[-h #new host name#]
[-k #new servername#]
[-o #new port number#]
[-t #new timeout value#]
[-p #new protocol name#]
[-l #new codepage name#]

deleteserver
-v #server name#

addserver
-v #server name#
-h #new host name#
[-o #new port number#]
[-t #new timeout value#]
[-p #new protocol name#]
[-l #new codepage name#]

createFolder
-n #folder name#
[-d #folder description#]
[-o #owner name#]
[-g #group name#]
[-s #shared folder#]
[-p #permissions#]

deleteFolder
-n #folder name#

modifyFolder
-n #folder name#
[-d #folder description#]
[-o #owner name#]
[-g #group name#]
[-s #shared folder#]
[-p #permissions#]
[-r #new name#]

truncatelog
-t #all | #endtime# (MM/DD/YYYY HH24:MI:SS)#
[-f #folder name#]
[-w #workflow name#]

createlabel
-a #label name#
[-c #comments#]

deletelabel
-a #label name#
[-f #force delete#]

applylabel
-a #label name#
{ [-n #object name#
-o #object type#
-t #object subtype#]
[-v #version number]
[-f #folder name#] }
{ [-i #persistent input file#] }
[-d #dependency object types#]
[-p #dependency direction (children, parents, or both)#]
[-s #include pk-fk dependency#]
[-g #across repositories#]
[-m #move label#]
[-c #comments#]

createdeploymentgroup
-p #deployment group name#
[-t #deployment group type (static or dynamic)#]
{ [-q #query name#]
[-u #query type (shared or personal)#] }
[-c #comments#]

deletedeploymentgroup
-p #deployment group name#
[-f #force delete#]

cleardeploymentgroup
-p #deployment group name#
[-f #force clear#]

addtodeploymentgroup
-p #deployment group name#
{ [-n #object name#
-o #object type#
-t #object subtype#]
[-v #version number]
[-f #folder name#] }
{ [-i #persistent input file#] }
[-d #dependency types (all, non-reusable or none)#]

findcheckout
[-o #object type#]
[-f #folder name#]
[-u #all users#]
[-c #column separator]
[-r #end-of-record separator#]
[-l #end-of-listing indicator#]
[-b #verbose#]

checkin
-o #object type#
[-t #object subtype#]
-n #object name#
-f #folder name#
-c #comments#

undocheckout
-o #object type#
[-t #object subtype#]
-n #object name#
-f #folder name#

executequery
-q #query name#
[-t #query type (shared or personal)#]
[-u #output persistent file name#]
[-a #append#]
[-c #column separator]
[-r #end-of-record separator#]
[-l #end-of-listing indicator#]
[-b #verbose#]

listobjectdependencies
{ [-n #object name#
-o #object type#
-t #object subtype#]
[-v #version number]
[-f #folder name#] }
{ [-i #persistent input file#] }
[-d #dependency object types#]
-p #dependency direction (children, parents, or both)#
[-s #include pk-fk dependency#]
[-g #across repositories#]
[-u #output persistent file name#]
[-a #append#]
[-c #column separator]
[-r #end-of-record separator#]
[-l #end-of-listing indicator#]
[-b #verbose#]

deployfolder
-f #folder name#
-c #control file name#
-r #target repository name#
[-n #target repository user name#
[-x #target repository password# |
-X #target repository password environment variable#]
-h #target repserver host name#
-o #target repserver port number#]
[-l #log file name#]

deploydeploymentgroup
-p #deployment group name#
-c #control file name#
-r #target repository name#
[-n #target repository user name#
[-x #target repository password# |
-X #target repository password environment variable#]
-h #target repserver host name#
-o #target repserver port number#]
[-l #log file name#]

objectimport
-i #input xml file name#
-c #control file name#
[-l #log file name#]

objectexport
{ [-n #object name#
-o #object type#
-t #object subtype#]
[-v #version number]
[-f #folder name#] }
{ [-i #persistent input file#] }
[-m #export pk-fk dependency#]
[-s #export objects referred by shortcut#]
[-b #export non-reusable dependents#]
[-r #export reusable dependents#]
-u #xml output file name#
[-l #log file name#]

validate
{ [-n #object name#
-o #object type (mapplet, mapping, session, worklet, workflow)#
[-v #version number]
[-f #folder name#] }
{ [-i #persistent input file#] }
[-s #save upon valid#]
{ [-k #check in upon valid#
-m #check in comments#] }
[-p #output option types (valid, saved, skipped, save_failed, invalid_before, invalid_after, or all)#]
[-u #output persistent file name#]
[-a #append#]
[-c #column separator]
[-r #end-of-record separator#]
[-l #end-of-listing indicator#]
[-b #verbose#]

addrepository
-h #repserver host name#
-o #repserver port number#
[-a #repserver password# |
-A #repserver password environment variable#]
-r #repository name#
-t #database type#
-u #database user name#
[-p #database password# |
-P #database password environment variable#]
[-m (Trusted Connection, valid for Microsoft SQL Server only)]
-c #database connect string#
[-d #code page name#]
[-e #DB2 tablespace name#]

stoprepository
[-a #repserver password# |
-A #repserver password environment variable#]
[-h #hostname#
-o #port number#
-r #repository name#]

enablerepository
-h #hostname#
-o #port number#
[-a #repserver password# |
-A #repserver password environment variable#]
-r #repository name#

disablerepository
-h #hostname#
-o #port number#
[-a #repserver password# |
-A #repserver password environment variable#]
-r #repository name#

register
-r #repository name#
-n #repository user name#
[-x #repository password# |
-X #repository password environment variable#]
[-a #GDR repserver password#
-A #GDR repserver password environment variable#]
[-h #LDR host name# (only if LDR is managed by a different RepServer)
-o #LDR port number# (only if LDR is managed by a different RepServer)]

unregister
-r #repository name#
-n #repository user name#
[-x #repository password# |
-X #repository password environment variable#]
[-a #GDR repserver password#
-A #GDR repserver password environment variable#]
[-h #LDR host name# (only if LDR is managed by a different RepServer)
-o #LDR port number# (only if LDR is managed by a different RepServer)]

notify
-h #hostname#
-o #port number#
[-a #repserver password# |
-A #repserver password environment variable#]
-r #repository name#
-t #notify | broadcast# (message type)
-m #message#

help
help [command].
Print help. If command is specified print help for command, else print help for all commands

cleanup
help completed successfully.

Informatica 7.1:How to import/export images into Oracle tables through INFA?

2007-01-08T18:46:00.000+05:30

Informatica till 7.1 version does not support images/pdfs/zip files.
But still we can do so by standard Oracle way by calling stored procedures into INFA MAPPING.
Please check for the stored procedures:
Oracle interMedia User's Guide and Reference
From ASK TOM ( Good article )

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

Informatica 7.1: How to import export using shell script

2006-12-29T20:27:00.000+05:30

The following script is useful to export various mappings from DEV environment and then import into QA environment.

1/ Firstly run.sh which will export mappings from DEV and then will import into QA.You have total flexibility while this export-import process.

$ cat run.sh
################################################################
# Script: This script will do import export of mappings using two sub scripts
# Author: M.A.Hasim
# Modification: Create on 28th Dec 2006
# Modification
# History:
# Calling: exportHasim_v1.sh,importHasim_v1.sh
# Called By:
##################################################################
echo "Info...Starting Export.\n"
exportHasim_v1.sh
echo "Info...Completed Export.\n"
sleep 5
echo "Info...Starting Import.\n"
importHasim_v1.sh
echo "Info...Completed Import.\n"
sleep 3
echo "Info...Everything Successful...Good Luck [ Hasim ].\n"

2/ This is an environment file to make things alive.Like as INFORMATICA repository name,folder name.Database parameters,Scrript location,log location etc.

$ cat .my_env
# INFA DEV PARAMETERS
REPODEV=devuser; export REPODEV
REPODEVUSER=Hasim; export REPODEVUSER
REPODEVUSERPASSWORD=Hasim; export REPODEVUSERPASSWORD
REPODEVHOST=utopia; export REPODEVHOST
REPODEVPORT=6410; export REPODEVPORT

# INFA QA PARAMETERS
REPOQA=qauser; export REPOQA
REPOQAUSER=Hasim; export REPOQAUSER
REPOQAUSERPASSWORD=Hasim; export REPOQAUSERPASSWORD
REPOQAHOST=utopia; export REPOQAHOST
REPOQAPORT=6510; export REPOQAPORT

# DATABASE LEVEL PARAMETERS #
$CNCTSTRNGORACLEDEV=devuser/devpasswd@devdatabase; export $CNCTSTRNGORACLEDEV
$CNCTSTRNGORACLEQA=qauser/qapasswd@qadatabase; export $CNCTSTRNGORACLEQA

# LOG ETC
LOG=/mnt/home/abulhasim/IMPEXPMAPPINGS/log; export LOG
SCRPT=/mnt/home/abulhasim/IMPEXPMAPPINGS/script; export SCRPT

3/ This is the main script used for exporting mappings.

$ cat exportHasim_v1.sh
####################################################
# Script: This script will export mappings from INFA Repository .
# Author: M.A.Hasim
# Modification: Create on 28th Dec 2006
# Modification
# History:
# Calling: clctexpobj_v1.sql
# Called By:
####################################################

# Setting all of the environment variables
. .my_env
DT=`date +%m%d%y%H%M%S`
echo "Info....Starting Export."

# Collecting Mappings to be imported and then creating Objectexport statement for pmrep
# and then making a unix script on the fly to be used in command
# the following sql will create a exportHasimmapng_v1.run script which we will use in
# command.So we need change the mode also.
sqlplus -s $CNCTSTRNGORACLE @clctexpobj_v1.sql
CHK1=`wc -l exportHasimmapng_v1.runcut -d" " -f1`
if [ $CHK1 -eq 0 ]; then
echo "Err....Please make exp_stat as 'W' in tmp_infa \n"
exit;
fi
chmod 777 exportHasimmapng_v1.run
mv exportHasimmapng_v1.run /mnt/home/abulhasim/informatica/repositoryserver

# Changing directory to INFA repository
cd /mnt/home/abulhasim/informatica/repositoryserver

# Lets connect to the repository first and then export
pmrep connect -r $REPODEV -n $REPODEVUSER -x $REPODEVUSERPASSWORD -h $REPODEVHOST -o $REPODEVPORT
if [ $? -ne 0 ];then
echo "Err...Connection with the repository $REPODEV failed.\n"
exit;
fi

# Now we will export
# The content of exportHasimmapng_v1.run is like
# objectexport -u 123T456_exportHasim.xml -n Trial -f GDC_PRACTICE -o Mapping -l 123T456_exportHasim.log
pmrep run -f exportHasimmapng_v1.run -o exportHasim$DT.log -e Hasim

if [ $? -ne 0 ];then
echo "Err...Connection with the repository $REPODEV failed.\n"
exit;
fi

# Now we will collect all three files(two logs having the string exportHasim and the other pmrep script
# generated into pmrepository directory for clean up purpose and dump into this local dir

#mv *exportHasim*.log $LOG
cp *exportHasim*.xml $SCRPT
#mv *exportHasim.xml $SCRPT

#rm -f exportHasimmapng_v1.run
cd -
# Update tmp_infa exp_stat uncomment in original run
#sqlplus -s $CNCTSTRNGORACLE @updtMasterTblExpStat.sql

4/ This is the main script for importing mappings.

$ cat importHasim_v2.sh
##########################################################################################################
# Script: This script will import mappings from one Repository to the other
# Author: M.A.Hasim
# Modification: Create on 28th Dec 2006
# Modification
# History:
# Calling:
# Called By:
##########################################################################################################

# Setting environment
. .my_env
# Removing all lst files
rm -f ImpExpData.lst conflictstatfrmtbl.lst
#rm -f *.lst *.xml
echo "Info....Starting Import."

# Collecting SOURCEFOLDERNAME,SOURCEREPOSITORYNAME,TARGETFOLDERNAME,TARGETREPOSITORYNAME
sqlplus -s $CNCTSTRNGORACLE @colctSrcTgtData_v1.sql

# Grep the conflictstatfrmtbl.lst file to get those values into UNIX variable
SOURCEFOLDERNAME=`cat ImpExpData.lstcut -d"" -f1`
SOURCEREPOSITORYNAME=`cat ImpExpData.lstcut -d"" -f2`
TARGETFOLDERNAME=`cat ImpExpData.lstcut -d"" -f3`
TARGETREPOSITORYNAME=`cat ImpExpData.lstcut -d"" -f4`
CHECKINCOMMENTS=`cat ImpExpData.lstcut -d"" -f5`
CHECKINLABEL=`cat ImpExpData.lstcut -d"" -f6`

echo "----- Source and Target Info -----"
echo "Info....SOURCEFOLDERNAME:$SOURCEFOLDERNAME"
echo "Info....SOURCEREPOSITORYNAME:$SOURCEREPOSITORYNAME"
echo "Info....TARGETFOLDERNAME:$TARGETFOLDERNAME"
echo "Info....TARGETREPOSITORYNAME:$TARGETREPOSITORYNAME"
echo "Info....CHECKINCOMMENTS:$CHECKINCOMMENTS"
echo "Info....CHECKINLABEL:$CHECKINLABEL"
echo "-----------------------------------"
echo "Info....Sleeping 1 secs.Press CNTRL-C if you not satisfied with the Info"
sleep 1

# Collecting conflict info from table tmp_infa_conflict and collect those into spool file conflictstatfrmtbl.lst
sqlplus -s $CNCTSTRNGORACLE @createCntrlXml_v1.sql

# Grep the conflictstatfrmtbl.lst file to get those values into UNIX variable
changeno=`cat conflictstatfrmtbl.lstcut -d"" -f1`
cpeno_ttno=`cat conflictstatfrmtbl.lstcut -d"" -f2`
mapng_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f3`
src_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f4`
trg_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f5`
exp_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f6`
fltr_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f7`
agg_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f8`
rank_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f9`
norm_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f10`
rtr_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f11`
seq_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f12`
sort_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f13`
updstrt_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f14`
custtrnsfrmtn_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f15`
lkp_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f16`
trnsctncntrl_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f17`
sp_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f18`
extproc_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f19`
joiner_cnflct=`cat conflictstatfrmtbl.lstcut -d"" -f20`

echo "----- Control XML Info -----"
echo "Info....CHANGE NO:$changeno"
echo "Info....CPENO TTNO:$cpeno_ttno"
echo "Info....MAPPING CONFILCT:$mapng_cnflct"
echo "Info....SOURCE CONFLICT:$src_cnflct"
echo "Info....TARGET CONFLICT:$trg_cnflct"
echo "Info....EXPRESSION CONFLICT:$exp_cnflct"
echo "Info....FILTER CONFLICT:$fltr_cnflct"
echo "Info....AGGREGATOR CONFLICT:$agg_cnflct"
echo "Info....RABK CONFLICT:$rank_cnflct"
echo "Info....NORMALIZER CONFLICT:$norm_cnflct"
echo "Info....ROUTER CONFLICT:$rtr_cnflct"
echo "Info....SEQUENCE CONFLICT:$seq_cnflct"
echo "Info....SORTER CONFLICT:$sort_cnflct"
echo "Info....UPDATE STRATEGY CONFLICT:$updstrt_cnflct"
echo "Info....CUSTOM TRANSFORMATION CONFLICT:$custtrnsfrmtn_cnflct"
echo "Info....LOOKUP CONFLICT:$lkp_cnflct"
echo "Info....TRANSACTION CONFLICT:$trnsctncntrl_cnflct"
echo "Info....STORED PROCEDURE CONFLICT:$sp_cnflct"
echo "Info....EXTERNAL PROCEDURE CONFLICT:$extproc_cnflct"
echo "Info....JOINER CONFLICT:$joiner_cnflct"
echo "-----------------------------------"
echo "Info....Sleeping 1 secs.Press CNTRL-C if you not satisfied with the Info"
sleep 1

# The control xml file for inporting objects will be of naming convention like 123T456.xml
CNTRLXML=importHasim$changeno_$cpeno_ttno.xml
# .
# .
# Check the pic above for this portions code.Blogger mess up with angular brackets of XML
# .
# .
# Creting run script for pmrep
IMPRTRUN=importHasim$changeno.$cpeno_ttno.run
echo "ObjectImport -i $cpeno_ttno"_exportHasimCore.xml" -c $CNTRLXML" >$IMPRTRUN
cp $IMPRTRUN /mnt/home/abulhasim/informatica/repositoryserver
cp $CNTRLXML /mnt/home/abulhasim/informatica/repositoryserver
cp $cpeno_ttno"_exportHasimCore.xml" /mnt/home/abulhasim/informatica/repositoryserver >>/dev/null 2>&1
if [ $? -ne 0 ];then
echo "Err....There are no xml files to import."
echo "Err....There should must be matching entry in master tables tmp_infa and tmp_infa_conflict"
exit;
fi
# Changinf directory to PMREp
cd /mnt/home/abulhasim/informatica/repositoryserver

pmrep connect -r $REPOQA -n $REPOQAUSER -x $REPOQAUSERPASSWORD -h $REPOQAHOST -o $REPOQAPORT
pmrep run -f $IMPRTRUN -o importHasim$DT.log -e Hasim
#if [ $? -ne 0 ];then
#echo "Err....Error occurred while importing"
cat importHasim.log
#else
#echo "Update exp status"
#sqlplus -s $CNCTSTRNGORACLEDEV @updtMasterTblImpStat_v1.sql
#fi
mv *importHasim* $LOG
cd -

5/ This a master table which keeps track of the changes you are about to made
The structure of tmp_infa is as follows:-

CREATE TABLE tmp_infa
(
changeno NUMBER(5) NOT NULL,
cpeno_ttno VARCHAR2(300) NOT NULL,
exp_fldr VARCHAR2(300),
exp_rep VARCHAR2(300),
exp_objct VARCHAR2(300),
exp_objcttyp VARCHAR2(300),
exp_objctsubtyp VARCHAR2(300),
exp_stat VARCHAR2(90) DEFAULT 'W',
imp_fldr VARCHAR2(300),
imp_rep VARCHAR2(300),
imp_chkincmnts VARCHAR2(600),
imp_chkinlbl VARCHAR2(600),
imp_stat VARCHAR2(90) DEFAULT 'W'
)

6/ This is another details table which will be used to resolve conflict issues while importing back mappings into QA repository.

Table structure of tmp_infa_conflict is as follows:-

CREATE TABLE tmp_infa_conflict
(
changeno NUMBER(5) NOT NULL,
cpeno_ttno VARCHAR2(300) NOT NULL,
mapng_cnflct VARCHAR2(24),
src_cnflct VARCHAR2(24),
trg_cnflct VARCHAR2(24),
exp_cnflct VARCHAR2(24),
fltr_cnflct VARCHAR2(24),
agg_cnflct VARCHAR2(24),
rank_cnflct VARCHAR2(24),
norm_cnflct VARCHAR2(24),
rtr_cnflct VARCHAR2(24),
seq_cnflct VARCHAR2(24),
sort_cnflct VARCHAR2(24),
updstrt_cnflct VARCHAR2(24),
custtrnsfrmtn_cnflct VARCHAR2(24),
lkp_cnflct VARCHAR2(24),
trnsctncntrl_cnflct VARCHAR2(24),
sp_cnflct VARCHAR2(24),
extproc_cnflct VARCHAR2(24),
joiner_cnflct VARCHAR2(24)
)

7/ This query is used to collect information from a master table named tmp_infa

$ cat clctexpobj_v1.sql
SET NEWPAGE 1
SET SPACE 0
SET LINESIZE 180
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET TERMOUT OFF
SET TRIMSPOOL ON
SET VERIFY OFF

spool exportHasimmapng_v1.run
select 'objectexport -n 'exp_objct' -o 'exp_objcttyp' -f 'exp_fldr' -u 'cpeno_ttno'_exportHasimCore.xml'' -l 'cpeno_ttno'_exportHasim.log' from TMP_INFA where exp_stat = 'W' order by changeno;
spool off;
exit;

8/ Update script to update tmp_infa export status as 'S' after successfully exported.

$ cat updtMasterTblExpStat.sql
update tmp_infa set exp_stat = 'S' where exp_stat = 'W';
commit;
exit;

9/ colctSrcTgtData_v1.sql is to collect informations to which QA informatica folder we are to import of which informatica repository.

$cat colctSrcTgtData_v1.sql
SET NEWPAGE 1
SET SPACE 0
SET LINESIZE 180
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET TERMOUT OFF
SET TRIMSPOOL ON
SET VERIFY OFF

spool ImpExpData.lst
select exp_fldr''exp_rep''imp_fldr''imp_rep''imp_chkincmnts''imp_chkinlbl from tmp_infa where exp_stat = 'W';
spool off;
exit;

10/ createCntrlXml_v1.sql is to collect all conflict related issues while importing.
You will have all informations related to confilct in tmp_infa_conflict table.

$ cat createCntrlXml_v1.sql
SET NEWPAGE 1
SET SPACE 0
SET LINESIZE 180
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET TERMOUT OFF
SET TRIMSPOOL ON
SET VERIFY OFF

spool conflictstatfrmtbl.lst

select
cnflct.changeno ''
cnflct.cpeno_ttno ''
mapng_cnflct ''
src_cnflct ''
trg_cnflct ''
exp_cnflct ''
fltr_cnflct ''
agg_cnflct ''
rank_cnflct ''
norm_cnflct ''
rtr_cnflct ''
seq_cnflct ''
sort_cnflct ''
updstrt_cnflct ''
custtrnsfrmtn_cnflct ''
lkp_cnflct ''
trnsctncntrl_cnflct''
sp_cnflct ''
extproc_cnflct ''
joiner_cnflct
from tmp_infa_conflict cnflct,tmp_infa main
WHERE
cnflct.CHANGENO=main.CHANGENO
AND cnflct.CPENO_TTNO=main.CPENO_TTNO
AND main.imp_stat = 'W';

spool off;
exit;

11/ updtMasterTblImpStat_v1.sql is to update the status of tmp_infa table import status to S after successfully imported the mappings.

$ cat updtMasterTblImpStat_v1.sql
update tmp_infa set imp_stat = 'S' where imp_stat = 'W';
commit;
exit;

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

Informatica 7.1:How to invoke sessions through UNIX shell scripting.

2006-12-27T18:13:00.000+05:30

In most of the ETL environment having INFA installed in UNIX we used to invoke sessions by UNIX.

1/
It gives better control.
2/
Can be embedded in a UNIX ETL scripts and thus can the process be automated.
3/
Can do all things which you can do in GUI mode.

You can invoke a session using pmcmd command.
A typical script may look like as follows:
.
.
.
.
. .my_env #Environment file having all the variables which
# we will use in PMCMD command.
.
.
# Some more logic- May be collecting info regarding all the sessions to be
# picked up alongwith their folder name from a Master table of the database.
.
.
.
PMCMD_STATUS=pmcmd startworkflow -u $INFO_USER -p $INFO_PWD -s $INFO_PORT -f $INFO_FOLDER -paramfile $INFO_PARAMFILE -nowait $INFO_SESSION
.
# Check whether your session has successfully instantiated or not.
.
if [ $PMCMD_STATUS -ne 0 ]; then
echo "\n Error Occurred... `date +%m%d%y%H%M%S`: The Informatica Session Named $INFO_SESSION Failed"
exit;
else
echo "\n Cheers... `date +%m%d%y%H%M%S`: The Informatica Session Named $INFO_SESSION Successfully Started on `date +%m%d%y%H%M%S`\n"
fi
.
# Do something- Blah blah blah
.
.
.

Informatica Workflow Administration guide is a good help for doing such things from command line mode.

All available tasks which can be performed by pmcmd are as follows:

$ pmcmd
pmcmd>
pmcmd> help
Usage: help [command]
Usage: version
Usage: pingserver
Usage: getserverproperties
Usage: shutdownserver <-complete|-stop|-abort>
Usage: getserverdetails [-all|-running|-scheduled]
Usage: getrunningsessionsdetails
Usage: startworkflow [<-folder|-f> folder]
[<-startfrom> taskInstancePath [<-recovery>]]
[<-paramfile> paramfile] [-wait|-nowait] workflow
Usage: stopworkflow [<-folder|-f> folder] [-wait|-nowait] workflow
Usage: abortworkflow [<-folder|-f> folder] [-wait|-nowait] workflow
Usage: waitworkflow [<-folder|-f> folder] workflow
Usage: resumeworkflow [<-folder|-f> folder] [-wait|-nowait] [<-recovery>]
workflow
Usage: scheduleworkflow [<-folder|-f> folder] workflow
Usage: unscheduleworkflow [<-folder|-f> folder] workflow
Usage: getworkflowdetails [<-folder|-f> folder] workflow
Usage: starttask [<-folder|-f> folder] <-workflow|-w> workflow
[<-paramfile> paramfile] [-wait|-nowait] [<-recovery>]
taskInstancePath
Usage: stoptask [<-folder|-f> folder] <-workflow|-w> workflow [-wait|-nowait]
taskInstancePath
Usage: aborttask [<-folder|-f> folder] <-workflow|-w> workflow [-wait|-nowait]
taskInstancePath
Usage: waittask [<-folder|-f> folder] <-workflow|-w> workflow taskInstancePath
Usage: resumeworklet [<-folder|-f> folder] <-workflow|-w> workflow
[-wait|-nowait] [<-recovery>] taskInstancePath
Usage: gettaskdetails [<-folder|-f> folder] <-workflow|-w> workflow
taskInstancePath
Usage: getsessionstatistics [<-folder|-f> folder] <-workflow|-w> workflow
taskInstancePath
Usage: connect <-serveraddr|-s> [host:]portno
<<-user|-u> username|<-uservar|-uv> userEnvVar>
<<-password|-p> password|<-passwordvar|-pv> passwordEnvVar>
Usage: disconnect
Usage: setwait
Usage: setnowait
Usage: unsetfolder
Usage: setfolder folder
Usage: showsettings
Usage: exit

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

X MAS 2006

2006-12-27T11:25:00.000+05:30

And finally thats the look of our theme.And yah....It was a prize winning theme.Judges praised a lot.Wore our badges till the day end.And we successfully hammered our message to everyone`s mind...A message for a MERRY CHRISTMAS in reality for future...With that motto we have started.
Looking forward for next X MAS.....Hasim

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

X MAS 2006

2006-12-27T11:22:00.000+05:30

We have also made some badges for all team members and judges.Above all we were successful to make this X MAS different.

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

X MAS 2006

2006-12-27T11:19:00.000+05:30

We were innovative in the idea of presenting a JAR OF RICE to the judges through Santa.
Our clear message by gifting that is TO REMIND THE GRIM SITUATION OF POVERTY SURROUND US WHEREAS SO MUCH FOOD IS GETTING WASTED.
---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

X MAS 2006

2006-12-27T11:13:00.000+05:30

We choosed the tag line "Make Poverty History".We thought to have a globe having embedded our tag line by thermocol.
But managing such a huge globe was a big task.Somehow our members managed that from a Gym.They managed to grab a blue crystal ball.

We were late in decoration.While making hurry in cutting thermocols I accidentally cut my hand.

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

X MAS 2006

2006-12-27T11:06:00.000+05:30

Again another 25th came to remind me that I am getting older and also to celebrate X MAS in our office.But this time I had some constraints and thats why I was not ready to initiate things.But anyway I was there to decorate things.
We have thought to celebrate X MAS with a difference.With a different message.With a new resolution.

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

PGP ERROR:received signal 11 and Unable to open default key rings

2006-12-19T11:02:00.000+05:30

PROBLEM:
-----------
The problem "Unable to open default key rings" came when I was to decrypt a pgp file.
And then to investigate this I wanted to see the keys in our keyring as we have updated a key days before and then I got stucked in "received signal 11"

Actually we have more than one users in that specific UNIX system.And whereas one user ( user2 ) can see pgp -kv but another user ( (user1) is getting error while trying to see the keyring.

user2/home$ pgp -kv
Pretty Good Privacy(tm) Version 6.5.8
(c) 1999 Network Associates Inc.
Uses the RSAREF(tm) Toolkit, which is copyright RSA Data Security, Inc.
Export of this software may be restricted by the U.S. government.

Type bits/keyID Date User ID
pub 1024/4812D8FF 2002/07/19 hasim
sec 1024/45FD19FA 2003/10/20 mahasim
2 matching keys found.

0 memory frags found
exitPGP: exitcode = 0

user1/home$ pgp -kv
Pretty Good Privacy(tm) Version 6.5.8
(c) 1999 Network Associates Inc.
Uses the RSAREF(tm) Toolkit, which is copyright RSA Data Security, Inc.
Export of this software may be restricted by the U.S. government.

received signal 11

0 memory frags found
exitPGP: exitcode = 6

user1/home$ pgp +force -z "My PGP Key" samplefile.pgp
Pretty Good Privacy(tm) Version 6.5.8
(c) 1999 Network Associates Inc.
Uses the RSAREF(tm) Toolkit, which is copyright RSA Data Security, Inc.
Export of this software may be restricted by the U.S. government.

Error: Unable to open default key rings.
0 memory frags found
exitPGP: exitcode = 32

SOLUTION
-----------
I have checked the MANPATH,PATH for both users and did not get any difference.Later I have discovered that some files permission has been changed ( read permission has been removed for user1 ) in pgp home directory.I granted read permission to all users and it started working fine.

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

HOW TO ESCAPE SPECIAL CHARACTER IN SQL QUERY IN Oracle9i Enterprise Edition Release 9.2.0.6.0

2006-12-11T13:25:00.000+05:30

Select * from emp;

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
7369 SMITH_N CLERK 7902 17-Dec-1980 1064.8 20
7499 ALLEN_
SALESMAN 7698 20-Feb-1981 1600 300 30

select * from emp where ename like '%*_%' escape '*' --Here we are telling to escape the character(s) immetiadely after the asterisk.

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
7369 SMITH_N CLERK 7902 17-Dec-1980 1064.8 20

select * from emp

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
7369 SMITH_%N CLERK 7902 17-Dec-1980 1064.8 20
7499 ALLEN% SALESMAN 7698 20-Feb-1981 1600 300 30
7521 WARD SALESMAN 7698 22-Feb-1981 1250 500 30
7566 JONES MANAGER 7839 2-Apr-1981 3959.73 20
7654 MARTIN SALESMAN 7698 28-Sep-1981 1250 1400 30
7698 BLAKE MANAGER 7839 1-May-1981 2850 30
7782 CLARK MANAGER 7839 9-Jun-1981 3260.95 10
7788 SCOTT ANALYST 7566 9-Dec-1982 3993 20
7839 KING PRESIDENT 17-Nov-1981 6655 10
7844 TURNER SALESMAN 7698 8-Sep-1981 1500 0 30
7876 ADAMS CLERK 7788 12-Jan-1983 1464.1 20
7900 JAMES CLERK 7698 3-Dec-1981 950 30
7902 FORD ANALYST 7566 3-Dec-1981 3993 20
7934 MILLER CLERK 7782 23-Jan-1982 1730.3 10

select * from emp where ename like '%*_*%%' escape '*' --Here we are telling to escape the character(s) immetiadely after the asterisk
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
7369 SMITH_%N CLERK 7902 17-Dec-1980 1064.8 20

select * from emp

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
7369 SMITH&N CLERK 7902 17-Dec-1980 1064.8 20
7499 ALLEN% SALESMAN 7698 20-Feb-1981 1600 300 30
7521 WARD SALESMAN 7698 22-Feb-1981 1250 500 30
7566 JONES MANAGER 7839 2-Apr-1981 3959.73 20
7654 MARTIN SALESMAN 7698 28-Sep-1981 1250 1400 30
7698 BLAKE MANAGER 7839 1-May-1981 2850 30
7782 CLARK MANAGER 7839 9-Jun-1981 3260.95 10
7788 SCOTT ANALYST 7566 9-Dec-1982 3993 20
7839 KING PRESIDENT 17-Nov-1981 6655 10
7844 TURNER SALESMAN 7698 8-Sep-1981 1500 0 30
7876 ADAMS CLERK 7788 12-Jan-1983 1464.1 20
7900 JAMES CLERK 7698 3-Dec-1981 950 30
7902 FORD ANALYST 7566 3-Dec-1981 3993 20
7934 MILLER CLERK 7782 23-Jan-1982 1730.3 10

select * from emp where ename like '%*&%' escape '*'
13:19:36 ORA-01424: missing or illegal character following the escape character --As '&' does not have any special meaning in pattern-search in SQL query.

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

Informatica 7.1:How to validate multiple mappings in one shot....Unix Shell Script

2006-11-17T13:02:00.000+05:30

In my previous post the I have described the problem while validating multiple mappings.
Here is the script to find out which mappings are valid and whcih are invalid....

##########################################################################################################
# Script: This is the wrapper script to collect invalid objetcs at one shot of informatica. #
# Author: M.A.Hasim
# Modification:
# Modification
# History: 11-16-2006-- INTIAL VERSION
# Calling: fetch_object_map_v1.sql
# Called By: None
##########################################################################################################

. .my_env
rm -f mappingcheckhasim_v1.sh validoutput.txt
echo "Collecting Objects To Be Validated...."
if [ $# -eq 0 ];
then
sqlplus -s $CNCTDEV @fetch_object_map_full.sql
chmod 777 mappingcheckhasim_v1.sh
totmapno=`wc -l mappingcheckhasim_v1.sh|cut -d" " -f1`
cp mappingcheckhasim_v1.sh $PM_HOME/../repositoryserver
cd $PM_HOME/../repositoryserver
echo "Starting Validation of $totmapno mappings...."
echo "At -----`date`----- Please wait..It May Take Some Time..."
exec
pmrep $PMREPCONDEV
if [ $? -eq 0 ];
then
echo "Connected With Infa...Parsing..Wait..It may take some time..."
fi;
pmrep run -f mappingcheckhasim_v1.sh -o validoutput.txt -e Hasim
if [ $? -ne 0 ];
then
errormapping=`tail -10 validoutput.txt|grep 'validate -n'|cut -d" " -f3`
echo "Internal Error Occurred While validating $errormapping"
echo "If you wish to get Info about remaining mappings..."
echo "Run again"
echo "Please dont delete mails untill you become sure you got all info..."
fi;
wait
#exit 0
echo "Validation Finished at -----`date`-----Sending Mail..."
rm -f mappingcheckhasim_v1.sh
cd -
mv $PM_HOME/../repositoryserver/validoutput.txt .
grep 'is VALID **' validoutput.txt>validmappings.txt
grep 'is INVALID ***' validoutput.txt>invalidmappings.txt
totvalidmapno=`wc -l validmappings.txt|cut -d" " -f1`
totinvmapno=`wc -l invalidmappings.txt|cut -d" " -f1`
if [ -s validmappings.txt ];then
cat validmappings.txt|mailx -s "$totvalidmapno Valid mappings in DEV " m_a_hasim@yahoo.com
else
echo "No Valid mappings in DEV"| mailx -s "No Valid mappings in DEV " m_a_hasim@yahoo.com
fi;

if [ -s invalidmappings.txt ];then
cat invalidmappings.txt|mailx -s "$totinvmapno Invalid mappings in DEV " m_a_hasim@yahoo.com
else
echo "No Invalid mappings in DEV"| mailx -s "No Invalid mappings in DEV " m_a_hasim@yahoo.com
fi;

echo "Cheers...Go Ahead..."

else

echo "Starting after mapping $1......"
sqlplus -s $CNCTDEV @fetch_object_map_partial.sql $1
chmod 777 mappingcheckhasim_v1.sh
totmapno=`wc -l mappingcheckhasim_v1.sh|cut -d" " -f1`
cp mappingcheckhasim_v1.sh $PM_HOME/../repositoryserver
cd $PM_HOME/../repositoryserver
echo "Starting Validation of $totmapno mappings...."
echo "At -----`date`----- Please wait..It May Take Some Time..."
exec
pmrep $PMREPCONDEV
if [ $? -eq 0 ];
then
echo "Connected With Infa...Parsing..Wait..It may take some time..."
fi;
pmrep run -f mappingcheckhasim_v1.sh -o validoutput.txt -e Hasim
if [ $? -ne 0 ];
then
errormapping=`tail -10 validoutput.txt|grep 'validate -n'|cut -d" " -f3`
echo "Internal Error Occurred While validating $errormapping"
echo "If you wish to get Info about remaining mappings..."
echo "Run again"
echo "Please dont delete mails untill you become sure you got all info..."
fi;
wait
#exit 0
echo "Validation Finished at -----`date`-----Sending Mail..."
rm -f mappingcheckhasim_v1.sh
cd -
mv $PM_HOME/../repositoryserver/validoutput.txt .
grep 'is VALID **' validoutput.txt>validmappings.txt
grep 'is INVALID ***' validoutput.txt>invalidmappings.txt
totvalidmapno=`wc -l validmappings.txt|cut -d" " -f1`
totinvmapno=`wc -l invalidmappings.txt|cut -d" " -f1`

if [ -s validmappings.txt ];then
cat validmappings.txt|mailx -s "$totvalidmapno Valid mappings in DEV after error Occured in $1" m_a_hasim@yahoo.com
else
echo "No Valid mappings in DEV after error Occured in $1"| mailx -s "No Valid mappings in DEV after error Occured in $1 " m_a_hasim@yahoo.com
fi;
if [ -s invalidmappings.txt ];then
cat invalidmappings.txt|mailx -s "$totinvmapno Invalid mappings in DEV after error Occured in $1" m_a_hasim@yahoo.com
else
echo "No Invalid mappings in DEV after error Occured in $1"| mailx -s "No Invalid mappings in DEV after error Occured in $1 " m_a_hasim@yahoo.com
fi;
echo "Cheers...Go Ahead..."
fi;

Steps Followed:-
1/
Collected all mappings to be validated.
2/
Made pmrep statements for validation.
3/
sorted valid mappings and invalid mappings in different files.
4/
Mailed them.

Error Handling:-
Some times wat happened is,while validating,pmrep got stuck for some mappings and come out.That time my scipt will tell that there is a problem while validating any specific mapping.And then will give you option to start validating remaining mappings.

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

Informatica 7.1 : How to validate all mappings in a reposirory in one shot

2006-11-16T19:03:00.000+05:30

Problem :
We are to upgrade INFA7.1 to INFA8.1.The most common problem is after upgrading many mappings just become invalid which remains valid before upgradation.We faced that problem while exporting-importing also.
So our first concern is to find out
i/
which mappings becomes invalid after upgradation
ii/
Sort out them.Fix them.
iii/
Restore them.

But the first task iteself is tough as we have almost 700 mappings on run.So its tedious and cumbersome if we are to check them manually one by one.

Solution:
I have automated the whole process of cheking which will tell you which mapping are invalid after parsing them.

Process:
i/
INFA has its own repository in which it keeps all records,status about all mappings.
At first we are to find out from the metadata level which mappings are of which status.
So we will creat a wrapper unix shell ( main_map_check_hasim_v1.sh ) in which we will call a sql script having the following sql code.

select 'validate -n '||parent_mapping_name||' -o mapping -f '||parent_subject_area||' -p valid,invalid_before,invalid_after -b' from rep_all_mappings where order by parent_subject_area

ii/
we will take all the output in one spool file which will be the feeder for the main unix script ( pmrep_map_check_hasim_v1.sh ).

iii/
making that mappingcheckhasim_v1.sh excecutable.

iv/
invoke pmrep-->connect-->call that mappingcheckhasim_v1.sh with appropriate parameters.

connect -r repositoryname -n repositoryuser -x repositorypassword -h repositoryhostname -o repositorportno

run -f validchekhasimrun.sh -o validoutput.txt
run -f invalidchekhasimrun.sh -o invalidoutput.txt

v/
Exit from pmrep,look for the output file which has been created by pmrep.grep it for 'invalid' entities,create file for those invalid mappings,send it to prospective users.

Enhancement:

i/
Help developers giving them the reson for invalid mappings.
ii/
Help developers assisting them to validate it.
iii/
Help developers assisting them to save it.
iv/
Help developers assisting them to check-in it with proper message.
---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

Informatica Error: ORA-00932: inconsistent datatypes: expected %s got %s

2006-11-03T15:57:00.000+05:30

The error is something like this which you can collect from sessionlog.

READER_1_1_1> BLKR_16007 Reader run started.
READER_1_1_1> RR_4029 SQ Instance [SQ_Shortcut_To_table_A] User specified SQL Query [SELECT table_A.field1,table_A.field2, table_A.field3, table_A.field4, table_A.field5, table_A.field6, table_A.field7, table_A.field8, table_A.field9, table_A.field10, table_A.field11, table_A.field12, table_A.field13, table_A.field14, table_A.field15, table_A.field16
FROM Schema_a.table_A
WHERE
table_A.field10 IS NOT NULL AND
table_A.field11 = 'N']
READER_1_1_1> Thu Nov 02 21:37:13 2006
READER_1_1_1> RR_4035 SQL Error [
ORA-00932: inconsistent datatypes: expected %s got %s

Resolution:-Check your SQL qualifier transformation,validate the SQL Query.And then keep on checking other transformations whether any inconsistent data flow is happenning there.In my case I was trying to squeeze records from one port(number(10,2)) of SQL Source Qualifier tranasformation to the target port(decimal(8)) of the Expression Transformation.And hence was the error.

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

Renaming Of A Table...And a Headache

2006-10-31T19:15:00.000+05:30

A silly mistake and a headache can also be the headline of this post.We took the backup of a table A to table bckup_B,then dropped A and renamed bckup_B to A.And then ran our process.Data was coming absolutely fine through a procedure.But we were getting null values in a field.And we were finding thorugh that bigggg procedures up and down to find out why that field is not getting populated.Later we have discovered that in original table ddl that field having a default value.So....The moral of the story.Alwaysss take a backup of the DDL of a table also if you are planning to drop that table later.

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

How to--Informatica7.1:How to create a simple normalizer

2006-09-30T18:27:00.000+05:30

How to create a simple normalizer....?

We need a normalizer to normalize the denormalized data.Means if data is coming in denormalized format from source we simply want to to store in normalize format in target.

Say..if the data in the source table is like

ENAME SAL1 SAL2 SAL3
ram 100 200 300
sha 1100 2200 3300

And its might possible if in the source table some hitorical data maintaining is going on.
But while migrating say you want data like this...

NAME ALLJOB
ram 100
ram 200
ram 300
sha 1100
sha 2200
sha 3300

Then we can do it by normalizer transformation.Normalizer creates multiple rows from a single row.Most of the times normalizer is used for cobol data source.
In edit normalizer transformation-->normalizer tab-->create two fields as we have two incoming ports from the source transformation,here you need to know which one is master and which one is detail fields among the two.In our case ENAME is the master and SAL is the detail field.And for each MASTER,detail is to be repeated thrice in the target.So make the occurence of the detail field in normalizer tab as three.-->connecty the input port appropriately with the incoming transformation and output port with the target table.

GK and GCID
==============
GK and GCID is informatica generated keys and can be used as unique identifier of the new normalized data.GK will be increased one by one for each insertion of rows into the target table and GCID will have rotating values as per the number of occurance of detail field in the source.A sample run and the result from target is:

NAME ALLJOB GK_ALLSAL GCID_ALLSAL
ram 100 1 1
ram 200 2 2
ram 300 3 3
sha 1100 4 1
sha 2200 5 2
sha 3300 6 3

Still I dont know much about the level in normalizer tab..:(
---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

Informatica 7.1 : Error TE_7016; port unbound in some Transformation

2006-08-03T13:48:00.000+05:30

This is mainly a transformation error.
According to Troubleshooting guide:

=========================================================
TE_7016: Failed to allocate/intialize server transformation < transformation name >
Cause: Internal allocation or initialization error.
Action: Contact Informatica technical support.
=========================================================

In such case check for unconnected ports in transformations.And specially be aware while importing/exporting mappings from one env to another.In that time the ports may be disconnected.

My blog is not responsible for any damages happened from the suggestion of my blog :-Reach me at : m_a_hasim@yahoo.com

Informatica 7.1:Informatica Session terminated unexpectedly;LM_36401

2006-07-31T20:43:00.000+05:30

In the troubleshooting guide it has been written like:

================================================================
LM_36401 Execution terminated unexpectedly
Cause: The DTM process did not stop,abort or fail properly.
Action: Contact Informatica Technical Support.
================================================================

Error Description:
You run a session.The session just failed without being picked up properly.And the log is also of very few lines telling the "Failed to fetch session instance properly".

I tried many times.The same thing happened.I tried in google and got a solution like this:

http://datawarehouse.ittoolbox.com/groups/technical-functional/informatica-l/error-code-36401-execution-terminated-unexpectedly-1087284

As per the solution told in above webpage:
1/
I removed the repositoryserver log.
I removed the pmserver log.
I removed the repagent log.

2/
I truncated log from repository manager console.

3/
I revalidated mapping and workflows associated with that session.

4/I shut down pmrepserver as well as pmserver and then again re-start.

But every single things I did of no help.

Lastly I got this beautiful scripts:

SELECT A.SUBJ_NAME ,B.MAPPING_NAME ,C.WIDGET_ID ,C.INSTANCE_NAME
FROM OPB_SUBJECT A ,OPB_MAPPING B ,OPB_WIDGET_INST C
WHERE A.SUBJ_ID=B.SUBJECT_ID AND B.MAPPING_ID =C.MAPPING_ID AND
B.VERSION_NUMBER = C.VERSION_NUMBER AND C.WIDGET_TYPE=15 AND
B.IS_VISIBLE > 0 AND C.WIDGET_ID IN
(select w.WIDGET_ID from opb_widget_field wf, opb_widget w
where w.widget_type = 15 and w.widget_id = wf.widget_id and
w.version_number = wf.version_number and w.is_visible > 0
and wf.widget_fld_prop = 0 and wf.porttype = 2)

If the above query returns more than one row in the result set then
apply the following update query.

CREATE TABLE OPB_WIDGET_FIELD_BACKUP AS SELECT * FORM OPB_WIDGET_FIELD;

update opb_widget_field set widget_fld_prop =
(select f2.field_id from opb_widget_field f2, opb_widget w
where f2.widget_id = opb_widget_field.widget_id and f2.version_number
= opb_widget_field.version_number and f2.widget_id = w.widget_id and
f2.version_number = w.version_number and w.is_visible > 0 and
w.widget_type = 15 and f2.field_name =
substr(opb_widget_field.field_name,1,length(opb_widget_field.field_name)
-1))
where widget_fld_prop=0 and porttype = 2 and exists (select * from
opb_widget w where w.widget_type = 15 and w.is_visible > 0 and
w.widget_id = opb_widget_field.widget_id and w.version_number =
opb_widget_field.version_number)

And yah,it solved that sticky problems.....:)

Informatica 7.1: Unexpected Condition Detected while Exporting Mapping ( Error in widgfld.cpp )

2006-07-30T11:43:00.000+05:30

A strange error is coming while I am trying to export a specific mapping. Strange error because when I am trying to export other mappings from the same repository,its working fine.But for this specific mapping the error is coming like this:

Direct Link:
http://img138.imageshack.us/img138/8899/exportingerror11zn9.jpg

I checked for any checkoutd for this mapping.---> No checkout was there.
I checked in repository manager for any Locks on this specific maping.---> No locks.
I tried to find out the error in Informatica Help.---> No such error messsges is there.

As the messages is showing not to continue more,I exit,--> Whole designer closed.And before the Designer prematurely exits,it shows another message like this:

Direct Link:
http://img138.imageshack.us/img138/2029/exportingerror21zg1.jpg

Action:-
1/
If that mapping contains any router delete that router and recreate it.

Informatica 7.1:Multiple Execute Error

2006-07-15T12:33:00.000+05:30

Well,now I am getting interested in Informatica a lot.I got amazed by its huge power of running query and prompting result in a very short span of time.

This error came when I was trying to implementing a router having two groups in it.And I made mistake while using conditions for those groups.Actually the condition set in one group may fetch data for the other group also.

Let me describe in details:
Emp ( src )
--------------

Eno Sal
--- ---
1 2000
2 3000
4 7000
5 2500
6 3500
7 5500

Now for a group I set condition like Sal > 2000 and for the another Sal > 3000.
SO the first group in fact fetching the data for the other group also.Here in lies the error.

So once you rectify it as Sal > 2000 and for the another Sal < 2000 the problem will be solved.

Informatica7.1: Installation Steps in WINDOWS XP ( Service Pack 2) Oracle 8i

2006-07-08T02:12:00.004+05:30

/************************************************
* INFORMATICA 7.1 Installation Steps
* OS: WINXP(SP-2)
* Oracle 8i
*************************************************/

1. Create an user for informatica metadata:-

DROP user utopia_user cascade;
CREATE USER utopia_user IDENTIFIED BY utopia_user DEFAULT TABLESPACE users QUOTA UNLIMITED ON users;
GRANT CONNECT,DBA TO utopia_user;

2. Configure IRS( Informatica Repository Sever ):-

Server port no-- 5858 ( say )
Administrator password-- 5858 ( say )
Remaining all--Keep as it is.

3. Create a New Repository Server:-

Go to ( RSAC )Repository server admin console.
Right click on Informatica Repository servers
-->New server registration.
Hostname--yours computer name.
Portnumber--IRS port number ( Here 5858 )
-->ok
Try to connect.

If its not getting connected,go to services and check whether Informatica Repository Service is running or not.If its not running,start it.

Again try to connect.

Repository server will be created as the same name as yours computer name. ( here utopia )
That utopia will have 4 things in it
>> Repositories
>>Activity Log
>>Backups
>>Available Packages

4. Create a new repository in the newly created repository server:-

-->Right click on that Repositories folder in the newly created repository server.

GENERAL TAB
------------
Repository Name--> utopia_rep
Keep remaining thing as it is.

DATABASE CONNECTION TAB
-------------------------
ConnectString-->orcl
DBUser-->utopia_user
Keep remaining thing as it is.

NETWORK TAB
-------------
Keep remaining thing as it is.

CONFIGURATION TAB
------------------
Keep remaining thing as it is.

LICENCE TAB
--------------
Update by all keys.

-->Apply

Once press the new repository will start creating.
-->ok
After finishes,double click on Repositories folder.You can see yours repository there (here utopia_rep)

5. Create a folder to work:-

Go to client-->Repository Manager ( RM ).
Double Click on your repository utopia_rep
Connect to repository dilog box will come
Username-->utopia_user
password-->utopia_user

Once connected.Go to menuber-->Folder-->Create
Create folder dialog box will come.
Name -->utopia_user_folder
Give its all permission
-->OK
Folder will be created.

6. Go to designer:-
Right Click on the repository ( utopia_rep ).-->connect
Username--> utopia_user
password-->utopia_user

-->connect
If you press on more,it will repository server info.The hostname and port number.
The folder jus created above will be shown there.
-->righ click and then open the folder.
-->Tools-->source analyzer ( to create a source )
-->go to source-->IMport from database.
-->ODBC data source ( Urs own created data source ).
-->user/password is from oracle user and password from which schema you want your source table.
-->Tools-->Warehouse Designer ( To Create a target )
-->Tools-->Mapping Designer ( To create a mapping )
Save the mapping and check whether its valid or not.

7.Go to Workflow Manager:-

-:Creating a session:-

Connect to the repository utopia_rep.
Open the utopia_user_folder.
Menu-->Tools -->Workflow Designer.
Menu-->Workflows-->Create a workflow.
GENERAL TAB
-----------
Name-->utopia_user_wrkflow1
Keep remaining things same.

PARAMETERS
-----------
Keep remaining things same.

SCHEDULER
----------
Keep remaining things same.

-: Creating a Task :-

Menu-->Tasks-->Create a task.
tasktype-->session
name-->utopia_user_task1
Once you press button,it will ask for a mapping associated with it.
Pick up that mapping we have created in mapping designer earlier.
-->ok.
-->Done

-: Linking the task and the session :-

Menu-->Tasks-->link task.
Save and check whether the workflow is valid or not.

8. Server configuration:-

Now we need to create a server in which our workflow will run.
For that
Menu-->Server-->server configuration-->new.
Server name -->utopia_user_wrkflow_server.
HOst name / IP address -->Computer name ( here utopia )
server variables-->Create a directory in your local disk ( here e:\demo )
and then $PMRoot directory -->e:\demo
Keep remaining things same.
Then -->resolve server-->ok.-->close
If the resolving done succesfully,then its fine else check...

9. Assigning the server to workflow:-
Close yours folder in Workflow Manager.Right click on the workflow server-->Assign to workflows
Check the folder and session-->assign.

10. Creating relational database connection:-
Menu-->connections-->relational-->type-->oracle-->
new-->name :relCon_utopia_user_src
user name-->scott-->password-->tiger-->connect string -->orcl

new-->name :relCon_utopia_user_tgt
user name--> utopia_user --> password --> utopia_user -->connect string -->orcl

Keep Workflow Manager open.We`ll come back here soon.

11. Setting Informatica Server Configuration:-

Go to STart-->Programs-->INformatica server setup.
Configure.

SERVER TAB
------------
server name-->utopia_user_wrkflow_server ( It should be same as workflow server name ).
TCP/IP Host address-->Keep it blank.
Keep remaining things same.

REPOSITORY TAB
---------------
repository name--> utopia_rep
Repository user --> utopia_user
Repository pasword --> utopia_user
Repository Server Host Name --> utopia ( Or your computer name )
Repository Sever Port Number --> 5858

LICENCE TAB
-----------------
Update all keys if they are not there.

COMPATIBILITY AND DATABASE
----------------------------
Keep remaining things same.

CONFIGURATION
---------------
Keep remaining things same.

JVM OPTIONS
----------------
Keep remaining things same.

HTTP PROXY
---------------
Keep remaining things same.

Apply-->ok-->exit
Go to services-->make informatica server up.

If facing problem to make it up-Check

12. Make workflow to run:-
Come back to Workflow Manager.double click on the session-->click on mapping tab.-->
click on source-->set the relational connection.
click on target -->set the relational connection-->normal load not bulk.

Save the workflow again and check if its valid or not.

13. And finally run the workflow:-
Right click on task and start workflow.

14. Check the success/failure status in Workflow monitor.

Informatica 7.1 : Informatica server is not running: Problem in resolving Host while creating server in workflow

2006-07-07T17:21:00.000+05:30

Is your sytem standalone/not connected to network?

Check in command prompt for your IP address.
For stand alone system its 127.0.0.1

Is your system connected with network/having NIC card, but you are not currently connected in network?

Connect to network.Resolve Host while creating server.Start Informatica service.

To find out Unique lines in a file in Unix---Continuation

2006-07-07T17:10:00.000+05:30

I had one post in my blog on Unique.And the solution was also there.This time I got a file ( say gg.txt ) contents like :

5570, 5570, 5570, 5570, 5570, 5578, 5594, 5570, 5570, 5585, 5570, 5570, 5570, 5570, 5570, 5570, 5585, 5570, 5570, 5570, 5570, 5570, 5570, 5570, 5585, 5570, 5570, 5585, 5570, 5585, 5570, 5570, 5570, 5585, 5570, 5570, 5585, 5570, 5570, 5585, 5570, 5570, 5570,

They are as different rows in the original file.I was to find out uniq records from them.When i ran:

$ sort -n gg.txt|uniq -c > hh.txt

The hh.txt file becomes like:

1 1220,
2 4273,
1 4582,
4 4683,
1 4790,
1 4933,
1 5043,
1 5086,
1 5214,
6 5363,
3 5390,
2 5396,
2 5460,
1 5462,
221 5476,
48 5477,
26 5478,
229 5479,
35 5480,
145 5481,
54 5482,
6 5483,
6409 5485,
52 5486,
29 5487,
12 5488,
2 5492,
1 5516,
7 5536,
48880 5570

The first column saying how many times that specific records occurred in the file gg.txt.

Although that migght be useful in cases,but I want the unique records only not their counts also as I am to build a SQL query on that output.So I ran this command

$ sort gg.txt|uniq > hhh.txt

And now the records become:

5476, 5477, 5478, 5479, 5480, 5481, 5482, 5483, 5485, 5486, 5487, 5488, 5570, 5578, 5585, 5594, 5598, 5599, 5605, 5608,

And thats wat I want.

The Idiot

2006-06-28T18:36:00.000+05:30

Asifbhai told me the story....Dont ask me who he is ? what is he doing...etc.,because in this blog entry I just want to share this superb story.
The story goes on like this...

Once upon a time there was bigg dynasty and the king was also bigggg.He had a big palace.And a big parliament where he had the masters of all field whom he choosed through various tough tests.He had renowed poet,elite harpooon thrower,tickling joker ...almost all masters from each profession were there in his court.And as the recognisation of their mastery in their respective fields,the king used to give a gold plated stick on which he had his own stamp.But here is a catch...If anyday any superior in any field came then the king is supposed to appoint the superior one and the unlucky courtier is supposed to handover the stick.

And then one day the idiot came..he was an utmost idiot...people could not but say him an idiot in every chances to talk with him....So he thought one day as the King did not have any idiot in his court,he could have take a chance!!!

So he went there and proposed the king to appoint him as one of the courtiers.The king thought-"Yah thats also true that I dint have any great idiot in my court".So he called a meeting,all courtiers came and finally the king agreed to take a test of that idiot and selected him seeing how much dumbo he is!!!.

Years passed by....one day our king got veryyyyy ill.All courtiers,per cortsey went to meet the king as his last day is nearby.The king was veryyy ill.What was the illness...?? I dont know.

Anyway,people asked that idiot whether he went to visit the king.He at first got very strange what is the need to go to see the king!!! And then he finally went.."My majesty,How are you?"
"I am fine,how are you"
"Good..My majesty...they are telling you are going to leave us...Why are you leaving us?"
"Because it was not my ultimate home...I need to go to my own home"
"Ooo..so you are going to your home...When will you come back?"
"I am not to come back again my child...thats my eternaaaal home,I`ll stay there forever"
"I see..So you must have made much bigger palace there as you are to stay there forever?"
"Dear,there is no palace."
"Okok..then you must have sent all of your money there...?"
"Nope"
"Then atleast all servants and maids you have already sent there as they are to make that place ready for you...is it My majesty?"
The king tolerated a lot.." You are a biggg idiot..!!!"
But here our idiot was really puzzled,he fumbled.."My majesty...Please take back my stick...in this world for staying only 60-70 years you made four palaces..you conquered so manyy battles...you have tons of gold and diamond...crores of servants and maids....But where you are saying you going to stay forever...You dint made a single palace...dint send a single servant or dint saved a single diamond...!!!My majest you are much more idiot than me...Please take back this stick"

Informatica 7.1: Source qualifier not generating SQL query

2006-06-10T01:19:00.000+05:30

The problem is very basic and logical also.To get rid of that at first flow all those ports to the next transformation.Then try to generate SQL query again.The simple fact is that untill you flows the ports ( or fixed up your mind about the Select SQL query)how can you genarate SQL?

The lil boy with a bigggg box.....

2006-05-30T18:59:00.000+05:30

I had a red shirt...a pair of small black shoes...

We had a favourite rhyme also which I used to recite whenever any new guests come into our house....That goes on like this ...." Red shirt black shorts/school uniform/black shoes white shocks....." I forgot the remaining line....

I had a biiiig box (having my name written on it)in compare to my age that time which I used to carry tiredly while coming back from my kindergarden....

I feel so tired while coming back from school that I used to set target while walking to cross and thinking in my mind so much distance to cross...so much distance is left to reach my home....

Setting target,I learnt in my childhood.....
After reaching this age....Am I loosing target.....

Yah...Thats very true,that sometimes yours childhood wakes you up....Cherish you...Revived you with a soothing mind...

To find out Unique lines in a file in Unix

2006-05-29T07:59:00.000+05:30

The problem came to me like this.
The content of a file(a.txt):

1001 Moron
1002 Michel
1003 Adam
1004 Harry
1001 Moron
1006 Madhu
1001 Moron
1002 Michael

The question was to create a new file on the basis of unique values on first column.
The idea to do that is:
>Sort the file by the first column
>Then find out unique columns.

So the solution is:
sort -n a.txt|uniq -c > b.txt
b.txt will be the intended file.

How To Change Unix Prompt To Show Present Working Directory?

2006-04-28T22:28:00.002+05:30

Its simple.May be a lottttt of pages in this vasssttt net will teach u the trick.But as per my own rule,I learnt,and Its my place to memorize.

Its like this:

$export PS1='$PWD>'

I dont know why-

$export PS1='$pwd>'
doesnt work.