HowToInfa: Informatica Best Practices

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

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

$ 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

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

The true bengali......

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.