Tuesday, June 22, 2010

Q&A

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
-------------------------------------------------------------