what is the location of parameter file in informatica?
How to partition the Session?
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
What is the need of etl tools?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
What is the difference between procedure and stored procedur?
Which are the different editions of informatica powercenter that are available?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
how can run the wf through pmcmd commend? write script?