ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Informatica
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
I want to run a informatica worklow after complition of 
oracle procedure. That procedure is not running through 
informatica and can be run at any time in database. 
Informatica is in windows environment. Is it possible ? If 
yes please explain.
 Question Submitted By :: Sachin Shrivastava
I also faced this Question!!     Rank Answer Posted By  
 
  Re: I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
Answer
# 1
This can  be possible with unix . Create a shell scripts
which  first has to Execute the stored procedure or Package
and we have command to check the completion or procedure
after that  use Pmcmd  command in the same unix to start the
workflow.
 
Is This Answer Correct ?    2 Yes 0 No
Deva
 
  Re: I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
Answer
# 2
Oracle proc can create a 0 byte file at the end of the proc 
and infa workflow can wait for the file (indicator file) to 
begin the execution.
 
Is This Answer Correct ?    1 Yes 0 No
Asha
 
 
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
what r the values tht r passed between informatics server and stored procedure?  1
Hi All can anyone tell me where i will get Informatica training in Mumbai?  2
why do u use shortcuts in informatica.? iFlex3
what are the differences between powercenter 8.1 and powercenter 8.5?  1
What is the term PIPELINE in informatica ? Deloitte4
What are the types of groups in Router transformation?  1
Which transformation should u need while using the cobol sources as source defintions?  2
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen. Accenture10
difference between shortcut and reusable transformation?  2
wht is full process of Information source to target just like stg to productuon and development Informatica1
what is polling?  1
What is the procedure to load the fact table.Give in detail?  1
how the server recognises , if the session fails after loading the 100 records in to the target TCS2
What are the session parameters?  2
how to convert the .doc docs into .txt format using informatica  1
What is the difference between view and materialised view?  5
what is difference between COM & DCOM? Satyam1
What is the difference between Bitmap and Btree index?  1
What are the options in the target session of update strategy transsformatioin?  2
What is the filename which you need to configure in UNIX while installing infromatica? Accenture2
 
For more Informatica Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com