The PowerCenter Server does not set the initial value for variables to NULL. Instead, the PowerCenter Server uses the following guidelines to set initial values for variables: Zero for numeric ports E...

The PowerCenter Server does not set the initial value for variables to NULL. Instead, the PowerCenter Server uses the following guidelines to set initial values for variables: Zero for numeric ports E...

hi

mapping is nothing but flow or work. where the data is coming and where data is going. for this we need

mapping name

source table

target table

session.

thanks

madhu

Please let me know the answer for this question.

Whenever any source data is changed we need to capture it in the target system also this can be basically in 3 waysTarget record is completely replaced with new record(Type 1)Complete changes can be c...

CDC Changed Data Capture. Name itself saying that if any data is changed it will how to get the values. for this one we have type1 and type2 and type3 cdc's are there. depending upon our requirement we can fallow.

thanks

madhu

hi

question itself there that data is quite freequently changing. Changing means it can be modify or added.

Example.

The best example of this one is Sales Table.

Rapidly changing dimension is that whre the dimensions changes quikly.

best example is ATM transactions(BANKS).The data being changes continuesly and concurently for each second so it is very difficult to capture this dimensions. 

You can actually create a view and import it as source in mapping ....

hi

for database procedure we have procedure transmission. we can use that one.

thanks

madhu

hi view direct connect to tableit wont contain data and what we ask it will fire on table and give the data.ex: sum(sal).materilized view are indirect connect to data and stored in separte scheema. it...

A materialized view provides indirect access to table data by storing the results of a query in a separate schema object unlike an ordinary view, which does not take up any storage space or contain da...

Rangini,Incremental Aggregations, I think informatica provides this feature to load the sessions which are abruptly termination in middle of the load, am I right? also I would like to know how you can...

The above answer is slightly correct.The incremental loading is done in 3 ways by using Transformations.1.Aggregate Transformation,2.Dynamic Lookup Transformation,3.Update Strategy Transformation,In t...

You cannot install informatica using the same CD that used for windows. You need to have a separate licence key for unix. Install process is quite simples , only you need to run the file called inst...

you need seperate licence key for unix.

I dont think windows licenese key works for UNIX.

srihari_t@yahoo.com

Lookup is not a join. Lookup is more similar to the real world example, you are conducting a interview and you have the list of registered candidates in hand. In oreder to see whether a candidate is registered or not, you'll look into the list and then verify. That's it.

hi

through sheduling

architecture is like1. Source Systems: Like Mainframe,Oracle,People soft,DB2.2. Landing tables: These are tables act like source. Usedfor easy to access, for backup purpose, as reusable forother mappi...

nice answer i have more doubts and can u give me ur mail id

to perform dml operations

thanks

madhu

Update Strategy is the most important transformation of all Informatica transformations.The basic thing one should understand about this is , it is essential transformation to perform DML operations o...

In Informatica 4 types of dimensions are available, these are 1) Degenerate dimensions 2) Junk dimesnsions ( a dimension which contains the less numbers of cordinality vales are less number of ind...

Hi Guys, Please don't answer wrong answers the above mentioned are Schema. , the dimension are discussed bellow. 1.Junk Dimension:Contains miscellaneous data such as flags and indicator 2.Degener...

Software could be corrupted or has attacked with Virus,
Re-install and if the problem persist then you change the OS and try Informatica, it may work.

In order to up your IRS, please follow up the guidelines:- 1) Create a database, if u have already DB exist, then u can go with the same. 2) Create two db users, give admin privilege to those users....