You can use nested IIF statements to test multiple conditions. The following example tests for various conditions and returns 0 if sales is zero or negative: IIF( SALES > 0, IIF( SALES < 50, SALARY1, IIF( SALES < 100, SALARY2, IIF( SALES ... Read More

Active Transformation: the transformation that change the no. of rows in the Target. Source (100 rows) ---> Active Transformation ---> Target (< or > 100 rows) Passive Transformation: the transformation that does not change the no. of... Read More

Informatica server,load manager/rs, data transfer manager,reader,temp server and writer are the components of informatica server. first load manager sends a request to the reader if the reader is ready to read the data from source and dump into the... Read More

Java Transformation available in the 8x version and it is not available in 7x version. Read More

while importing flat file definetion just specify the scale for a neumaric data type. in the mapping, the flat file source supports only number datatype(no decimal and integer). In the SQ associated with that source will have a data type as decimal... Read More

It only creates a copy of it.. Read More

Complex maping means involved in more logic and more business rules. Actually in my project complex mapping is In my bank project, I involved in construct a 1 dataware house Meny customer is there in my bank project, They r after taking loans... Read More

a) Create a lookup to target table from Source Qualifier based on primary Key. b) Use and expression to evaluate primary key from target look-up. ( If a new source record look-up primary key port for target table should return null). Trap this with... Read More

When the informatica server runs in the ASCII data movement mode it sorts session data using Binary sortorder.If you configure the seeion to use a binary sort order,the informatica server caluculates the binary value of each string and returns the... Read More

Junk Dimension A Dimension is called junk dimension if it contains attribute which are rarely changed ormodified. example In Banking Domain , we can fetch four attributes accounting to a junk dimensions like from the Overall_Transaction_master table... Read More

Intially the session should be valid session. source, target, lookups, expressions should be availble, min 1 break point should be available for debugger to debug your session. Read More

Correction the rejected data and send to target relational tables using loadorder utility. Find out the rejected data by using column indicatior and row indicator. Read More

Rank: 1 2<--2nd position 2<--3rd position 4 5 Same Rank is assigned to same totals/numbers. Rank is followed by the Position. Golf game ususally Ranks this way. This is usually a Gold Ranking. Dense Rank: 1 2<--2nd position 2<--3rd... Read More

There is no connected lookup t/r n by default it takes static cache.For insert n update operations we use dynamic cache. Read More

If you are focus is about the flat files then one can set it in file properties while creating a mapping or at the session level in session properties Read More

stop: _______If the session u want to stop is a part of batch you must stop the batch, if the batch is part of nested batch, Stop the outer most bacth Abort:---- You can issue the abort command , it is similar to stop command except it has 60... Read More

Question : What will happen if you are using Update Strategy Transformation and your session is configured for "insert"? What are the types of External Loader available with Informatica? If you have rank index for top 10. However if you... Read More

During the execution of workflow all the rejected rows will be stored in bad files(where your informatica server get installed;C:Program FilesInformatica PowerCenter 7.1Server) These bad files can be imported as flat a file in source then thro... Read More

We can use a MQSeries SQ when we have a MQ messaging system as source(queue). When there is need to extract data from a Queue, which will basically have messages in XML format, we will use a JMS or a MQ SQ depending on the messaging system. If you... Read More

Data sources ---> Data acquisition ---> Warehouse ---> Front end tools ---> Metadata management ---> Data warehouse operation management Read More

It depends upon our requirment only.If you have good processing database you can create aggregation table or view at database level else its better to use informatica. Here i’m explaing why we need to use informatica. what ever it may be... Read More

Specifies the directory used to cache master records and the index to these records. By default, the cached files are created in a directory specified by the server variable $PMCacheDir. If you override the directory, make sure the directory... Read More

If it is Type 2 Dimension the abouve answer is fine, but if u want to get the info of all the insert statements and Updates you need to use session log file where you configure it to verbose. You will get complete set of data which record was... Read More

In hash partitioning, the Informatica Server uses a hash function to group rows of data among partitions. The Informatica Server groups the data based on a partition key.Use hash partitioning when you want the Informatica Server to distribute rows... Read More

power center powermart no.of repository n No. n No. aplicability high end WH low&mid range WH global repository ... Read More

This is not there in Informatica v 7. but heard that its included in the latest version 8.0 where u can append to a flat file. Its about to be shipping in the market. Read More

Source based commit will commit the data into target based on commit interval.so,for every 10,000 rows it will commit into target. Target based commit will commit the data into target based on buffer size of the target.i.e., it commits the data into... Read More

Write a override sql query. Adjust the ports as per the sql query. Read More

The unconnected lookup is used just like a function call. in an expression output/variable port or any place where an expression is accepted(like condition in update strategy etc..), call the unconnected lookup...something like :LKP.lkp_abc... Read More

Question : What is the mapping for unit testing in Informatica, are there any other testings in Informatica, and how we will do them as a etl developer. how do the testing people will do testing are there any specific tools for testing ... Read More

The goal of performance tuning is optimize session performance so sessions run during the available load window for the Informatica Server.Increase the session performance by following. The performance of the Informatica Server is related to... Read More

Use filter transformation for loading the target with no duplicates. and for the other transformation load it directly from source. Read More

There r many ways to improve the mapping which has multiple lookups. 1) we can create an index for the lookup table if we have permissions(staging area). 2) divide the lookup mapping into two (a) dedicate one for insert means: source - target,,... Read More

It depends upon the informatica version we r using. suppose if we r using informatica 6 it supports only 32 partitions where as informatica 7 supports 64 partitions. Read More

EXPESSION transformation detects and flags the rows from source. Filter transformation filters the rows that are not flagged and passes the flagged rows to the Update strategy transformation Read More

Cache 1. Static cache 2. Dynamic cache 3. Persistent cache Read More

For example u have a table Emp_Name and it has two columns Fname, Lname in the source table which has douplicate rows. In the mapping Create Aggregator transformation. Edit the aggregator transformation select Ports tab select Fname then click the... Read More

Question : About Informatica Power center 7: 1) I want to Know which mapping properties can be overridden on a Session Task level. 2)Know what types of permissions are needed to run and schedule Work flows. Answers: 1.(Ans) You can... Read More

A target load order group is the collection of source qualifiers, transformations, and targets linked together in a mapping. Read More

1)lookup the flat files in informatica 7.X but we cann’t lookup flat files in informatica 6.X 2) External Stored Procedure Transformation is not available in informatica 7.X but this transformation included in informatica 6.X Read More

Question : When do u use a unconnected lookup and connected lookup.... what is the difference between dynamic and static lookup...y and when do v use these types of lookups ( ie...dynamic and static ) Answers: In static lookup ... Read More

To flag source records as INSERT, DELETE, UPDATE or REJECT for target database. Default flag is Insert. This is must for Incremental Data Loading. Read More

Session parameters are like maping parameters,represent values you might want to change between sessions such as database connections or source files. Server manager also allows you to create userdefined session parameters.Following are user defined... Read More

It is a ETL tool, you could not make reports from here, but you can generate metadata report, that is not going to be used for business analysis Read More

If u parttion a session with a relational target informatica server creates multiple connections to the target database to write target data concurently.If u partition a session with a file target the informatica server creates one target file for... Read More

Based on the requirement to your fact table, choose the sources and data and transform it based on your business needs. For the fact table, you need a primary key so use a sequence generator transformation to generate a unique key and pipe it to the... Read More

Three types of data:- Input/Out put parameters Return Values Status code. Read More

When the Informatica Server starts a recovery session, it reads the OPB_SRVR_RECOVERY table and notes the row ID of the last row committed to the target database. The Informatica Server then reads all sources again and starts processing from the next... Read More

When you start a workflow, you can optionally enter the directory and name of a parameter file. The Informatica Server runs the workflow using the parameters in the file you specify. For UNIX shell users, enclose the parameter file name in single... Read More

In a mapping we can use any number of transformations depending on the project, and the included transformations in the perticular related transformatons. Read More

Difference between static and dynamic cache- Static- Once the data is cached , it will not change. example unconnected lookup uses static cache. Dynamic- The cache is updated as to reflect the update in the table( or source) for which it is... Read More

Within a session: When you configure a session, yoYou can instruct the Informatica Server to either treat all records in the same way (for example, treat all records as inserts), or use instructions coded into the session mapping to flag records for... Read More

You can work with remote, But you have to Configure FTP Connection details IP address User authentication Read More

U can not. If u want to start batch that resides in a batch,create a new independent batch and copy the necessary sessions into the new batch. Read More

Relational source: To acess relational source which is situated in a remote place ,u need to configure database connection to the datasource. FileSource : To access the remote source file you must configure the FTP connection to the host machine... Read More

Basically fact tables are two kinds 1. Aggregated factable and Factless fact table. Agregated factable has aggregarted columns. for eg. Total-Sal, Dep-Sal. where as in factless factable will not have aggregated colums and it only has FK to the... Read More

U can create flat file definition in warehouse designer.in the warehouse designer,u can create new target: select the type as flat file. save it and u can enter various columns for that created target by editing its properties.Once the target is... Read More

We can use SCD Type 1/2/3 to load any Dimensions based on the requirement. Read More

The source qualifier transformation does not use sorted ports. If u change the partition information after the initial session fails. Perform recovery is disabled in the informatica server configuration. If the sources or targets changes after... Read More

Question : In certain mapping there are four targets tg1,tg2,tg3 and tg4. tg1 has a primary key,tg2 foreign key referencing the tg1’s primary key,tg3 has primary key that tg2 and tg4 refers as foreign key,tg2 has foreign key... Read More

Yes it can. For example...Flat File and Relations sources are joined in the mapping, and later, Flat File and relational targets are loaded. Read More

Informatica server log: Informatica server(on unix) creates a log for all status and error messages(default name: pm.server.log). It also creates an error log for error messages. These files will be created in informatica home directory:- Session... Read More

Go to the session log file there we will find the information regarding to the session initiation process, errors encountered. load summary. so by seeing the errors encountered during the session running, we can resolve the errors. Read More

Unit testing are of two types 1. Quantitaive testing 2.Qualitative testing Steps. 1.First validate the mapping 2.Create session on themapping and then run workflow. Once the session is succeeded the right click on session and go for... Read More

Inner equi join. Read More

The Designer provides two mapping wizards to help you create mappings quickly and easily. Both wizards are designed to create mappings for loading and maintaining star schemas, a series of dimensions related to a central fact table. Getting Started... Read More

If the session is configured to use in bulk mode it will not write recovery information to recovery tables. So Bulk loading will not perform the recovery as required. Read More

You should configure the mapping with the least number of transformations and expressions to do the most amount of work possible. You should minimize the amount of data moved by deleting unnecessary links between transformations. For transformations... Read More

IQD file is nothing but Impromptu Query Definetion,This file is maily used in Cognos Impromptu tool after creating a imr( report) we save the imr as IQD file which is used while creating a cube in power play transformer.In data source type we select... Read More

While importing flat file definetion just specify the scale for a neumaric data type. in the mapping, the flat file source supports only number datatype(no decimal and integer). In the SQ associated with that source will have a data type as decimal... Read More

Yes, we can use Informatica for cleansing data. some time we use stages to cleansing the data. It depends upon performance again else we can use expression to cleasing data. For example an feild X have some values and other with Null values and... Read More

Question : In a filter expression we want to compare one date field with a db2 system field CURRENT DATE. Our Syntax: datefield = CURRENT DATE (we didn’t define it by ports, its a system field ), but this is not valid (PMParser:... Read More

Input group Output group The designer copies property information from the input ports of the input group to create a set of output ports for each output group. Two types of output groups:- User defined groups Default group. You can not modify or... Read More

An unconnected transformation cant be connected to another transformation. but it can be called inside another transformation Read More

first u should convert diff. file format to one format then create 1 to 1 mapping,run it and see the o/p in unix whether file is posted or not. Read More

To work with remote datasource u need to connect it with remote connections.But it is not preferable to work with that remote source directly by using remote connections .Instead u bring that source into U r local machine where informatica server... Read More

Use pushdown optimization to push transformation logic to the source or target database. The Integration Service analyzes the transformation logic, mapping, and session configuration to determine the transformation logic it can push to the database.... Read More

By using Sequence GeneratorTransformation u can do it ie by chaging the RESET option in the properties tab of your SequenceGeneratorTransformation. then it will work Read More

A fact table is always DENORMALISED table. It consists of data from dimension table (Primary Key’s) and Fact table has Foreign keys and measures. Read More

Stop:We can Restart the session Abort:WE cant restart the session.We should truncate all the pipeline after that start the session Read More

I think this will be handled by the database we use. When the operations/loading on the table is in progress the table will be locked. If we are trying to load the same table with different partitions then we run into rowID erros if the database is... Read More

Its a session option. when the informatica server performs incremental aggr. it passes new source data through the mapping and uses historical chache data to perform new aggregation caluculations incrementaly. for performance we will use it. Read More

You specify the target loadorder based on source qualifiers in a maping.If you have the multiple source qualifiers connected to the multiple targets,You can designatethe order in which informatica server loads data into the targets. Read More

We have mainly tree ports Inport, Outport, Variable port. Inport represents data is flowing into transformation. Outport is used when data is mapped to next transformation. Variable port is used when we mathematical calculations are required. If any... Read More

May be you will encounter with connection faliure, other then that i don’t think so, cuzserver will handle all the syntex errors and Invalid mappings. Read More

use file repository concept. Read More

Simple Pass through maping : Loads a static fact or dimension table by inserting all rows. Use this mapping when you want to drop all existing data from your table before loading new data. Slowly Growing target : Loads a slowly growing fact or... Read More

In Dimensional modeling, Star Schema: A Single Fact table will be surrounded by a group of Dimensional tables comprise of de- normalized data Snowflake Schema: A Single Fact table will be surrounded by a group of Dimensional tables comprised of... Read More

Unconnected: The unconnected Stored Procedure transformation is not connected directly to the flow of the mapping. It either runs before or after the session, or is called by an expression in another transformation in the mapping. connected: The... Read More

Sorter is an active transformation. if you don’t check the distinct option it is considered as a passive transformation. becos this distinct option eliminates the duplicate records from the table. Read More

Two ways:- 1.Drag the port from another transforamtion 2.Click the add buttion on the ports tab. Read More

A set of worlflow tasks is called worklet, Workflow tasks means 1)timer2)decesion3)command4)eventwait5)eventrise6)mail etc...... But we r use diffrent situations by using this only Read More

Yes. By using Metadata reporter we can generate reports in informatica. Read More

Summary Filter --- we can apply records group by that contain common values. Detail Filter --- we can apply to each and every record in a database. Read More

You can add an aggregator before insert and group by the feilds that need to be distinct. Read More

Bitmap indexing a indexing technique to tune the performance of SQL queries. The default type is B-Tree indexers which is of high cardinality (normalized data). You can use bitmap indexers for de-normalized data or low cardinalities. The condition... Read More

1. Use test download option if you want to use it for testing. 2. Put counter/sequence generator in mapping and perform it. Read More

COBOL Copy-book files Read More

Yes! the answer provided is absolutely right. by an SQL application(Oracle). If you want to perform it thru informatica, the Fire the same query in the SQL Override of Source qualifier transformation and make a simple pass thru mapping. Other... Read More

Question : I have a situation here to load the Table into informatica. I have 5 temporary tables as sources. They look like: Table1: (K - Key, N-Null, X,Y,Z - values) K1 X N N N N K2 X N N N N -------------------------- Table2: ... Read More

A surrogate key is system genrated/artificial key /sequence number or A surrogate key is a substitution for the natural primary key.It is just a unique identifier or number for each row that can be used for the primary key to the table. The only... Read More

If multiple sessions in a concurrent batch fail, you might want to truncate all targets and run the batch again. However, if a session in a concurrent batch fails and the rest of the sessions complete successfully, you can recover the session as a... Read More

1.File is fixed width or delimited 2.Size of the file. If its can be executed without performance issues then normal load will work If its huge in GB they NWAY partitions can be specified at the source side and the target side. 3.File reader... Read More

Time Dimension will generally load manually by using PL/SQL , shell scripts, proc C etc...... Read More

Type1: Rows containing changes to existing dimensions are updated in the target by overwriting the existing dimension. In the Type 1 Dimension mapping, all rows contain current dimension data. Use the Type 1 Dimension mapping to update a slowly... Read More

In the Type2 maping we have three options to recognise the newly added rows Version number Flagvalue Effective date Range. Read More

the basic diff b/w inbetween informatica8.0and informatica7.0 is that in 8.0series informatica corp has introduces powerexchnage concept Read More

Normalizer: It is a transormation mainly using for cobol sources, it’s change the rows into coloums and columns into rows Normalization:To remove the retundancy and inconsitecy Read More

The informatica server follows instructions coded into update strategy transformations with in the session maping determine how to flag records for insert, update, delete or reject. If you do not choose data driven option setting,the informatica... Read More

Question : This is a scenario in which the source has 2 cols 10 A 10 A 20 C 30 D 40 E 20 C And there should be 2 targets one to show the duplicate values and another target for distinct rows. T1 T2 10 A 10 A 20 C ... Read More

We can start our required session only in case of sequential batch.in case of concurrent batch we cant do like this. Read More

When it encounters the DD_Reject in update strategy transformation. Violates database constraint Filed in the rows was truncated or overflowed. Read More

Various types of aggregation are SUM, AVG, COUNT, MAX, MIN, FIRST, LAST, MEDIAN, PERCENTILE, STDDEV, and VARIANCE. Read More

Use sorted input. Read More

You can not. If you want to start batch that resides in a batch,create a new independent batch and copy the necessary sessions into the new batch. Read More

Join data originating from same source data base. Filter records when the informatica server reads source data. Specify an outer join rather than the default inner join specify sorted records. Select only distinct values from the source. Creating... Read More

For incremental Aggregation.. We need to use Aggregations + Look up on Target + Expression to SUM up Count obtained from New Aggregations and Lookup on target. For one record already present in Aggregations table.. count is also there.. It will be... Read More

There is a lot of diffrence between informatica an Ab Initio In Ab Initio we r using 3 parllalisim but Informatica using 1 parllalisim In Ab Initio no scheduling option we can scheduled manully or pl/sql script but informatica contains 4... Read More

Parameter file is to define the values for parameters and variables used in a session.A parameter file is a file created by text editor such as word pad or notepad. You can define the following values in parameter file:- Maping parameters ... Read More

Yes.By setting the option always runs the session. Read More

Two options Run the session only if previous session completes sucessfully. Always runs the session. Read More

NO. Read More

Through Normalizer Transformation we can do this. Read More

You can use command line arguments for a session or batch.This allows you to change the values of session parameters,and mapping parameters and maping variables. Parallel data processing: This feature is available for powercenter only.If we use the... Read More

Two sources should have primary and Foreign key relation ships. Two sources should have matching data types. Read More

Materialized views are schema objects that can be used to summarize, precompute, replicate, and distribute data. E.g. to construct a data warehouse. A materialized view provides indirect access to table data by storing the results of a query in a... Read More

Narmalizer Transformation is used mainly with COBOL sources where most of the time data is stored in de-normalized format. Also, Normalizer transformation can be used to create multiple rows from a single row of data Read More

The informatica server builds a cache in memory when it processes the first row af a data in a cached look up transformation.It allocates memory for the cache based on the amount you configure in the transformation or session properties.The... Read More

The Informatica? PowerCenter? Partitioning option optimizes parallel processing on multiprocessor hardware by providing a thread-based architecture and built-in data partitioning. GUI-based tools reduce the development effort necessary to create... Read More

Yes.Because reusable tranformation is not contained with any maplet or maping. Read More

You can design using 2 methods using transformation developer create normal one and promote it to reusable Read More

When Informatica Server runs in UNICODE data movement mode ,then it uses the sort order configured in session properties. Read More

Join data originating from the same source database. You can join two or more tables with primary-foreign key relationships by linking the sources to one Source Qualifier. Filter records when the Informatica Server reads source data. If you... Read More

Pros: Loading, Sorting, Merging operations will be faster as there is no index concept and Data will be in ASCII mode. Cons: There is no concept of updating existing records in flat file. As there is no indexes, while lookups speed will... Read More

The model you choose constitutes your update strategy, how to handle changes to existing rows. In PowerCenter and PowerMart, you set your update strategy at two different levels: Within a session. When you configure a session, you can instruct the ... Read More

Infromatica Repository:The informatica repository is at the center of the informatica suite. You create a set of metadata tables within the repository database that the informatica application and tools access. The informatica client and server... Read More

By using command task. Read More

Constraint based load ordering example: Table 1---Master Tabke 2---Detail If the data in table1 is dependent on the data in table2 then table2 should be loaded first.In such cases to control the load order of the tables we need some conditional... Read More

ya Its Posible using pmcmd Command with out using the workflow Manager run the group of session. as per my knowledge i give the answer. Read More

Connected lookup:- 1> Receives input values diectly from the pipe line. 2> You can use a dynamic or static cache. 3> Cache includes all lookup columns used in the maping. 4> Support user defined default values. Unconnected lookup:- 1>... Read More

Two methods:- 1.Design it in the transformation developer. 2.Promote a standard transformation from the mapping designer.After you add a transformation to the mapping , You can promote it to the status of reusable transformation. Once you promote a... Read More

Source definitions. Definitions of database objects (tables, views, synonyms) or files that provide source data. Target definitions. Definitions of database objects or files that contain the target data. Multi-dimensional metadata. Target... Read More

You can Debug U?r maping in maping designer You can view the work space over the entire screen The designer displays a new icon for a invalid mapings in the navigator window You can use a dynamic lookup cache in a lokup transformation Create maping... Read More

Use Normalizer : create two ports - first port occurs = 1 second make occurs = 2 two output ports are created and connect to target Read More

The "Slowly Changing Dimension" problem is a common one particular to data warehousing. In a nutshell, this applies to cases where the attribute for a record varies over time. We give an example below: Christina is a customer with ABC Inc. She first... Read More

without common column or common data type we can join two sources using dummy ports. 1.Add one dummy port in two sources. 2.In the expression trans assing ’1’ to each port. 2.Use Joiner transformation to join the sources using dummy... Read More

Question : what is difference between lookup cashe and unchashed lookup? Can i run the mapping with out starting the informatica server? Answers: The difference between cache and uncacheed lookup iswhen you configure the lookup... Read More

Use a sorter transformation , in that u will have a "distinct" option make use of it . Read More

When you edit,schedule the sesion each time, informatica server directly communicates the repository to check whether or not the session and users are valid.All the metadata of sessions and mappings will be stored in repository. Read More

Load manager Process: Starts the session, creates the DTM process, and sends post-session email when the session completes. The DTM process. Creates threads to initialize the session, read, write, and transform data, and handle pre- and post-session... Read More

The aggregator stores data in the aggregate cache until it completes aggregate calculations.When you run a session that uses an aggregator transformation,the informatica server creates index and data caches in memory to process the transformation.If... Read More

You can use aggregator after update strategy. The problem will be, once you perform the update strategy, say you had flagged some rows to be deleted and you had performed aggregatortransformation for all rows, say you are using SUM function, then the... Read More

Rank transformation is used to find the status.ex if we have one sales table and in this if we find more employees selling the same product and we are in need to find the first 5 0r 10 employee who is selling more products.we can go for... Read More

You are supposed to define a parameter file. And then in the Parameter file, you can define two parameters, one for source and one for target. Give like this for example: $Src_file = c:program filesinformaticaserverinabc_source.txt $tgt_file = c:... Read More

This transformation is used to maintain the history data or just most recent changes in to target table. Read More

When a Joiner transformation occurs in a session, the Informatica Server reads all the records from the master source and builds index and data caches based on the master rows. After building the caches, the Joiner transformation reads records... Read More

Please refer to the documentation for more understanding. Mapping variables have two identities: Start value and Current value Start value = Current value ( when the session starts the execution of the undelying mapping) Start value <>... Read More

NO.Unless and until u join those three ports in source qualifier u cannot map them directly. Read More

If you stop a session or if an error causes a session to stop, refer to the session and error logs to determine the cause of failure. Correct the errors, and then complete the session. The method you use to complete the session depends on the... Read More

When the repo is up and the PMSERVER is also up, workflow monitor always will be connected on-line. When PMserver is down and the repo is still up we will be prompted for an off-line connection with which we can just monitor the workflows Read More

Yes, we can stop the batches using server manager or pmcmd commnad Read More

Cache is stored in the Informatica server memory and over flowed data is stored on the disk in file format which will be automatically deleted after the successful completion of the session run. If you want to store that data you have to use a... Read More

Its usually not done in the mapping(transformation) level. Its done in session level. Create a command task which will execute a shell script (if Unix) or any other scripts which contains the create index command. Use this command task in the... Read More

Joiner transformation compares each row of the master source against the detail source. The fewer unique rows in the master, the fewer iterations of the join comparison occur, which speeds the join process. Read More

A transaction can be define as DML operation. means it can be insertion,modification or deletion of data performed by users/ analysts/applicators Read More

confirmed dimension == one dimension that shares with two fact table factless means ,fact table without measures only contains foreign keys-two types of factless table ,one is event tracking and other is covergae table Bit map indexes ... Read More

Incremental aggregation is specially used for tune the performance of the aggregator. It captures the change each time (incrementally) you run the transformation and then performs the aggregation function to the changed rows and not to the entire... Read More

Most complex logic we use is denormalization. We dont have any Denormalizer transformation in INformatica. So we will have to use an aggregator followed by an expression. Apart from this, we use most of the complexicity in expression transformation... Read More

Use unconnected lookup if same lookup repeats multiple times. Read More

source--->sq--->exp-->sorter(with enable select distinct check box)--->t1 --->aggregator(with enabling group by and write count function)--->t2 If u want only duplicates to t2 u can follow this... Read More

Look up transformation is used to lookup the data in a relationa table,view,Synonym and Flat file. The informatica server queries the lookup table based on the lookup ports used in the transformation. It compares the lookup transformation port... Read More

In the fact table contain measurable data and less columns and meny rows, It’s contain primarykey Diffrent types of fact tables: additive,non additive, semi additive In the dimensions table contain textual descrption of data and also... Read More

if data in tables as follows Table A Key-1 char(3); table A values _______ 1 2 3 Table B bkey-a char(3); bcode char(1); table b values 1 T 1 A 1 G 2 A 2 T 2 L 3 A and output required is as 1, T, A 2, A, T, L 3, A the SQL query in source... Read More

Running the session in recovery mode will work, but the target load type should be normal. If its bulk then recovery wont work as expected Read More

Question : I want to prepare a questionnaire. The details about it are as follows: - 1. Identify a large company/organization that is a prime candidate for DWH project. (For example Telecommunication, an insurance company, banks, may be... Read More

ya shoor,Just right click on the particular session and going to recovery option or by using event wait and event rise Read More

Micro strategy is again an BI tool whicl is a HOLAP... u can create 2 dimensional report and also cubes in here.......basically a reporting tool. IT HAS A FULL RANGE OF REPORTING ON WEB ALSO IN WINDOWS. Read More

using Mystery Dimension ur maitaining the mystery data in ur Project. Read More

Cost based and rule based approaches are the optimization techniques which are used in related to databases, where we need to optimize a sql query. Basically Oracle provides Two types of Optimizers (indeed 3 but we use only these two techniques.... Read More

1) Filter transformation is an Active transformation and Lookup is a Passive transformation 2) Filter transformation is used to Filter rows based on condition and Lookup is used to to look up data in a flat file or a relational table, view, or... Read More

You can select these details from the repository table. you can use the view REP_SESS_LOG to get these data Read More

1. Determine if the incoming row is 1) a new record 2) an updated record or 3) a record that already exists in the table using two lookup transformations. Split the mapping into 3 seperate flows using a router transformation. 2. If 1) create a pipe... Read More

CREATE ONE PROCEDURE AND DECLARE THE SEQUENCE INSIDE THE PROCEDURE,FINALLY CALL THE PROCEDURE IN INFORMATICA WITH THE HELP OF STORED PROCEDURE TRANSFORMATION. Read More

Advanced External procedure tranformation and External procedure transformation: This transformation contains a check box on the properties tab to allow partitioning. Aggregator Transformation: If u use sorted ports You can not parttion the... Read More

Cleansing:---TO identify and remove the retundacy and inconsistency sampling: just smaple the data throug send the data from source to target Read More

As far my knowledge by using power exchange tool convert vsam file to oracle tables then do mapping as usual to the target table. Read More

For version control in ETL layer using informatica, first of all after doing anything in your designer mode or workflow manager, do the following steps..... 1> First save the changes or new implementations. 2>Then from navigator window, right... Read More

When the work flow is running slowly u have to find out the bottlenecks in this order target source mapping session system Read More

pmcmd is used to start a batch. Read More

If one of session is configured to "run if previous completes" and that previous session fails. Read More

Because in Data warehousing historical data should be maintained, to maintain historical data means suppose one employee details like where previously he worked, and now where he is working, all details should be maintain in one table, if u maintain... Read More

Question : can any one comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i. I mean how is oracle 9i advantageous when compared to oracle 8 or 8i when used in informatica Answers: it’s very... Read More

Grouping of session is known as batch. Batches are two types:- Sequential: Runs sessions one after the other Concurrent: Runs session at same time. If you have sessions with source-target dependencies you have to go for sequential batch to start the... Read More

Question : in the concept of mapping parameters and variables, the variable value will be saved to the repository after the completion of the session and the next time when u run the session, the server takes the saved variable value in the... Read More

In designer u will find the mapping parameters and variables options.u can assign a value to them in designer. comming to there uses suppose u r doing incremental extractions daily. suppose ur source system contains the day column. so every day u... Read More

Datamovement modes determines how informatcia server handles the charector data.U choose the datamovement in the informatica server configuration settings. Two types of datamovement modes avialable in informatica:- ASCII mode Uni code mode. Read More

Master thread: Creates and manages all other threads Maping thread: One maping thread will be creates for each session.Fectchs session and maping information. Pre and post session threads: This will be created to perform pre and post session... Read More

After the loadmanger performs validations for session,it creates the DTM process.DTM is to create and manage the threads that carry out the session tasks.I creates the master thread.Master thread creates and manges all the other threads. Read More

Master thread: Creates and manages all other threads Maping thread: One maping thread will be creates for each session.Fectchs session and maping information. Pre and post session threads: This will be created to perform pre and post session... Read More

Based on the requirement to your fact table, choose the sources and data and transform it based on your business needs. For the fact table, you need a primary key so use a sequence generator transformation to generate a unique key and pipe it to the... Read More

By using ODBC connection.if it is relational.if is flat file FTP connection..see we can make sure with connection in the properties of session both sources && targets. Read More

For a relational sources informatica server creates multiple connections for each parttion of a single source and extracts seperate range of data for each connection. Informatica server reads multiple partitions of a single source concurently... Read More

Configure the session to partition source data. Install the informatica server on a machine with multiple CPU?s. Read More

Partitioning achieves the session performance by reducing the time period of reading the source and loading the data into target. Read More

As per my knowledge there is no such restriction to use this number of sources or targets inside a mapping. Question is " if you make N number of tables to participate at a time in processing what is the position of your database. I orginzation... Read More

Informatica Server Manager. Read More

Maping: It is a set of source and target definitions linked by transformation objects that define the rules for transformation. Session : It is a set of instructions that describe how and when to move data from source to targets. Read More

In Designer while creating Update Strategy Transformation uncheck "forward to next transformation". If any rejected rows are there automatically it will be updated to the session log file. Update or insert files are known by checking the target... Read More

please be more specific on the first half of the question. u set the max no of concurrent sessions in the info server.by default its 10. u can set to any no. Read More

Type2 Dimension/Version Data Maping: In this maping the updated dimension in the source will gets inserted in target along with a new version number. Newly added dimension in source will inserted into target with a primary key. Type2 Dimension/... Read More

The best way to find out bottlenecks is writing to flat file and see where the bottle neck is . Read More

When u want to insert new record or update the existing data into the target i.e slowly changing dimension(scd type2) Read More

The best way to find out bottlenecks is writing to flat file and see where the bottle neck is . Read More

Itz possible to join the two or more tables by using source qualifier.But provided the tables should have relationship. When u drag n drop the tables u will getting the source qualifier for each table.Delete all the source qualifiers... Read More

Insert Delete Update Update as update Update as insert Update esle insert Truncate table Read More

When you create a version of a folder referenced by shortcuts, all shortcuts continue to reference their original object in the original version. They do not automatically update to the current folder version. For example, if you have a shortcut... Read More

Data driven. Read More

A Staging area in a DW is used as a temporary space to hold all the records from the source system. So more or less it should be exact replica of the source systems except for the laod startegy where we use truncate and reload options. So create... Read More

Repository is a database in which all informatica componets are stored in the form of tables. The reposiitory server controls the repository and maintains the data integrity and Consistency across the repository when multiple users useInformatica.... Read More

The main difference between informatica 5.1 and 6.1 is that in 6.1 they introduce a new thing called repository server and in place of server manager(5.1), they introduce workflow manager and workflow monitor. Read More

Features in 7.1 are : 1.union and custom transformation 2.lookup on flat file 3.grid servers working on different operating systems can coexist on same server 4.we can use pmcmdrep 5.we can export independent and dependent rep objects 6.we ca... Read More

It depends on the requirement. Otherwise Incremental load which can be better as it takes onle that data which is not available previously on the target. Read More

Top down ODS-->ETL-->Datawarehouse-->Datamart-->OLAP Bottom up ODS-->ETL-->Datamart-->Datawarehouse-->OLAP Read More

Status code provides error handling for the informatica server during the session.The stored procedure issues a status code that notifies whether or not stored procedure completed sucessfully.This value can not seen by the user.It only used by the... Read More

Summary filter can be applieid on a group of rows that contain a common value.where as detail filters can be applied on each and every rec of the data base. Read More

For populating and maintaining data bases. Read More

A Router transformation is similar to a Filter transformation because both transformations allow you to use a condition to test data. However, a Filter transformation tests data for one condition and drops the rows of data that do not meet the... Read More

No. we can’t do. I will explain you why. 1) Unless you assign the output of the source qualifier to another transformation or to target no way it will include the feild in the query. 2) source qualifier don’t have any variables... Read More

The Designer automatically creates a RANKINDEX port for each Rank transformation. The Informatica Server uses the Rank Index port to store the ranking position for<br>each record in a group. For example, if you create a Ranktransformation that... Read More

A "junk" dimension is a collection of random transactional codes, flags and/or text attributes that are unrelated to any particular dimension. The junk dimension is simply a structure that provides a convenient place to store the junk attributes. A... Read More

During the session ,the informatica server compares an inout row with rows in the datacache.If the input row out-ranks a stored row,the informatica server replaces the stored row with the input row.The informatica server stores group information... Read More

Normalizer Transformation. When you drag the COBOL source in to the mapping Designer workspace,the normalizer transformation automatically appears,creating input and output ports for every column in the source. Read More

Static cache: You can not insert or update the cache. Dynamic cache: You can insert rows into the cache as you pass to the target. Read More

In a STAR schema there is no relation between any two dimension tables, whereas in a SNOWFLAKE schema there is a possible relation between the dimension tables. Read More

In a relational data model, for normalization purposes, year lookup, quarter lookup, month lookup, and week lookups are not merged as a single table. In a dimensional data modeling(star schema), these tables would be merged as a single table called... Read More

Connected and unconnected lookups. Read More

To perform the following tasks:- Get a related value. For example, if your source table includes employee ID, but you want to include the employee name in your target table to make your summary data easier to read. Perform a calculation. Many... Read More

Manages the session and batch scheduling: Whe u start the informatica server the load maneger launches and queries the repository for a list of sessions configured to run on the informatica server.When u configure the session the loadmanager... Read More

You can write a mapping with the flat file as a target using a DUMMY_CONNECTION. A flat file target is built by pulling a source into target space using Warehouse Designer tool. Read More

Informatica Repository Server:It’s manages connections to the repository from client application. Informatica Server:It’s extracts the source data,performs the data transformation,and loads the transformed data into the target Read More

Normal (Default) Master outer Detail outer Full outer. Read More

Master and detail source Type of join Condition of the join. Read More

Both pipelines begin with the same original data source. Both input pipelines originate from the same Source Qualifier transformation. Both input pipelines originate from the same Normalizer transformation. Both input pipelines originate from the... Read More

I am providing the answer which I have taken it from Informatica 7.1.1 manual, Ans: While running a Workflow,the PowerCenter Server uses the Load Manager process and the Data Transformation Manager Process (DTM) to run the workflow and carry out... Read More

Data cleansing is a two step process including DETECTION and then CORRECTION of errors in a data set. Read More

There is no such restrication to place the source file. In performance point of view its better to place the file in server local src folder. if you need path please check the server properties availble at workflow manager. It doesn’t mean... Read More

No. Read More

Two ways 1. Edit the definition 2. Reimport the defintion Read More

Maping parameter represents a constant value that You can define before running a session.A mapping parameter retains the same value throughout the entire session. When you use the maping parameter ,U declare and use the parameter in a maping or... Read More

Normalizer transformaiton which is used to normalize the data.Since cobol sources r oftenly consists of Denormailzed data. Read More

COBOL source definition Joiner transformations Normalizer transformations Non reusable sequence generator transformations. Pre or post session stored procedures Target defintions Power mart 3.5 style Look Up functions XML source... Read More

A mapplet should have a mapplet input transformation which recives input values, and a output transformation which passes the final modified data to back to the mapping. when the mapplet is displayed with in the mapping only input & output... Read More

Reusable transformations can be used in multiple mappings.When you need to incorporate this transformation into maping,U add an instance of it to maping.Later if you change the definition of the transformation ,all instances of it inherit the... Read More

Transformations can be active or passive. An active transformation can change the number of rows that pass through it, such as a Filter transformation that removes rows that do not meet the filter condition. A passive transformation does not change... Read More

An unconnected transforamtion is not connected to other transformations in the mapping.Connected transforamation is connected to other transforamtions in the mapping. Read More

An active transforamtion can change the number of rows that pass through it.A passive transformation does not change the number of rows that pass through it. Read More

Source definitions. Definitions of database objects (tables, views, synonyms) or files that provide source data. Target definitions. Definitions of database objects or files that contain the target data. Multi-dimensional metadata. Target... Read More

NO. You might want to use a workflow parameter/variable if you want it to be visible with other mappings/sessions Read More

Maplet is a set of transformations that you build in the maplet designer and You can use in multiple mapings. Read More

Source qualifier ? Homogeneous source Joiner ? Heterogeneous source Read More

Normalizer transformaiton which is used to normalize the data.Since cobol sources are oftenly consists of Denormailzed data. Read More

This is no longer valid in version 7.2 Now we can use a joiner even if the data is coming from the same source. Read More

Master and detail source Type of join Condition of the join the Joiner transformation supports the following join types, which you set in the Properties tab: Normal (Default) Master Outer Detail Outer Full Outer Read More

Source name Database location Column names Datatypes Key constraints. Read More

Lookup Transformations can access data from relational tables that are not sources in mapping. With Lookup transformation, we can acomplish the following tasks:- Get a related value-Get the Employee Name from Employee table based on the Employee... Read More

Connected lookup Unconnected lookup Receives input values diectly from the pipe line. Receives input values from the result of a lkp expression in a another transformation. U can use a dynamic or static cache U can use a static... Read More

It represents all data queried from the source. Read More

Session - A Session Is A set of instructions that tells the Informatica Server How And When To Move Data From Sources To Targets. After creating the session, we can use either the server manager or the command line program pmcmd to start or stop the... Read More

The Normalizer transformation normalizes records from COBOL and relational sources, allowing you to organize the data according to your own needs. A Normalizertransformation can appear anywhere in a data flow when you normalize a relational source.... Read More

After the load manager performs validations for the session, it creates the DTM process. The DTM process is the second process associated with the session run. The primary purpose of the DTM process is to create and manage threads that carry out... Read More

The load Manager is the Primary Informatica Server Process. It performs the following tasks:- Manages session and batch scheduling. Locks the session and read session properties. Reads the parameter file. Expand the server and session... Read More

Based on which port you want generate Rank is known as rank port, the generated values are known as rank index. Read More

Code Page is used to identify characters that might be in different languages. If you are importing Japanese data into mapping, you must select the Japanese code page of source data. Read More

A Router transformation has the following types of groups: Input Output Input Group The Designer copies property information from the input ports of the input group to create a set of output ports for each output group. Output Groups There... Read More

Compatibility between code pages is used for accurate data movement when the Informatica Sever runs in the Unicode data movement mode. If the code pages are identical, then there will not be any data loss. One code page can be a subset or superset... Read More

A Stored Procedure transformation is an important tool for populating and maintaining databases. Database administrators create stored procedures to automate time-consuming tasks that are too complicated for standard SQL statements. Read More

When you add a relational or a flat file source definition to a mapping, you need to connect it to a Source Qualifier transformation. The Source Qualifier represents the rows that the Informatica Server reads when it executes a session. Join data... Read More

Aggregator transformation allows you to perform aggregate calculations, such as averages and sums. Read More

The Joiner transformation supports the following join types, which you set in the Properties tab: Normal (Default) Master Outer Detail Outer Full Outer Read More

Can identify existing rows of data using unconnected lookup transformation. Read More

The both the table should have a common field with same data type. Its not necessary both should follow primary and foreign relationship. If any relation ship exists that will help u in performance point of view. Read More

Target Options for File Target type are FTP File, Loader and MQ. There are no target options for ERP target type. Target Options for Relational are Insert, Update (as Update), Update (as Insert), Update (else Insert), Delete, and Truncate Table. Read More

Target Types are File, Relational and ERP. Read More

DATA DRIVEN Read More

The Informatica Server follows instructions coded into Update Strategy transformations within the session mapping to determine how to flag rows for insert, delete, update, or reject. If the mapping for the session contains an Update Strategy ... Read More

usage of stored procedure has the following advantages 1checks the status of the target database 2drops and recreates indexes 3determines if enough space exists in the database 4performs aspecilized calculation Read More

Update as Insert: This option specified all the update records from source to be flagged as inserts in the target. In other words, instead of updating the records in the target they are inserted as new records. Update else Insert: This option... Read More

Question : 1. can u explain one critical mapping? 2.performance issue which one is better? whether connected lookup tranformation or unconnected one? Answers: it depends on your data and the type of operation u r doing. If u need to... Read More

1. Simple Pass through 2. Slowly Growing Target Read More

i want whole information on slowly changing dimension.and also want project on slowly changing dimension in informatica. Read More

Type2 1. Version number 2. Flag 3.Date Read More

There r 3 types of dimensions 1.star schema 2.snowflake schema 3.glaxy schema Read More

Under certain circumstances, when a session does not complete, you need to truncate the target tables and run the session from the beginning. Run the session from the beginning when the Informatica Server cannot run recovery or when running... Read More

Informatica Workflow Managar and Informatica Worlflow Monitor Read More

If multiple sessions in a concurrent batch fail, you might want to truncate all targets and run the batch again. However, if a session in a concurrent batch fails and the rest of the sessions complete successfully, you can recover the session as a... Read More

If you configure a session in a sequential batch to stop on failure, you can run recovery starting with the failed session. The Informatica Server completes the session and then runs the rest of the batch. Use the Perform Recovery session property... Read More

Performance can be improved by processing data in parallel in a single session by creating multiple partitions of the pipeline. Informatica server can achieve high performance by partitioning the pipleline and performing the extract ,... Read More

For a relational sources informatica server creates multiple connections for each parttion of a single source and extracts seperate range of data for each connection.Informatica server reads multiple partitions of a single source concurently... Read More

A standalone session is a session that is not nested in a batch. If a standalone session fails, you can run recovery using a menu command or pmcmd. These options are not available for batched sessions. To recover sessions using the menu: 1. In the ... Read More

In addition, you can copy the workflow from the Repository manager. This will automatically copy the mapping, associated source,targets and session to the target folder. Read More

Batch--- is a group of any thing Different batches ----Different groups of different things. Read More

In case of storedprocedure transformation procedure will be compiled and executed in a relational data source.U need data base connection to import the stored procedure in to u?r maping.Where as in external procedure transformation procedure or... Read More

Partition’s can be done on both relational and flat files. Informatica supports following partitions 1.Database partitioning 2.RoundRobin 3.Pass-through 4.Hash-Key partitioning 5.Key Range partitioning All these are... Read More

Tracing level represents the amount of information that informatcia server writes in a log file. Types of tracing level:- Normal Verbose Verbose init Verbose data Read More

Maplet: one or more transformations Reusable transformation: only one transformation Read More

The PowerCenter repository allows you to share metadata across repositories to create a data mart domain. In a data mart domain, yoYou can create a single global repository to store metadata used across an enterprise, and a number of local... Read More

When you add a relational or a flat file source definition to a mapping, you need to connect it to a Source Qualifier transformation. The Source Qualifier represents the rows that the Informatica Server reads when it executes a session. Read More

The Informatica repository is a relational database that stores information, or metadata, used by the Informatica Server and Client tools. Metadata can include information such as mappings describing how to transform source data, sessions indicating... Read More

Maplet consists of set of transformations that is reusable.A reusable transformation is a single transformation that can be reusable. If u create a variables or parameters in maplet that can not be used in another maping or maplet.Unlike the... Read More

By Definiation, Active transformation is the transformation that changes the number of rows that pass through it...in union transformation the number of rows resulting from union can be (are) different from the actual number of rows. Read More

There are Factless Facts:Facts without any measures. Additive Facts:Fact data that can be additive/aggregative. Non-Additive facts: Facts that are result of non-additon Semi-Additive Facts: Only few colums data can be added. Periodic Facts: That... Read More

Factless Fact Tables are the fact tables with no facts or measures(numerical data). It contains only the foriegn keys of corresponding Dimensions. Read More

Look-up transformation can serve in so many situations. So, if you can a bit particular about the scenarioo that you are talking about, it will be easy to interpret. Read More

Change data capture (CDC) is a set of software design patterns used to determine the data that has changed in a database so that action can be taken using the changed data. Read More

Just run the session in time stamp mode then automatically session log will not overwrite current session log. Read More

Informatica server is the main server component in informatica product family..Which is resonsible for reads the data from various source system and tranforms the data according to business rule and loads the data into the target table Read More

1.? Open the mapping you want to migrate.? Go to File Menu - Select ’Export Objects’ and give a name - an XML file will be generated.? Connect to the repository where you want to migrate and then select File Menu - ’Import Objects... Read More

Question : I was working in SQL server, now i got an golden opertunity to work in INFORMATICA. I have lots of (silly) Questions to build my Career, so pls guide me properly. I will ask lots of questions.... What is the process flow of... Read More

You have to use two joiner transformations.fIRST one will join two tables and the next one will join the third with the resultant of the first joiner. Read More

U can use SQL query for uniqness if the source is Relational But if the source is Flat file then u should use Shorter or Aggregatot transformation Read More

Direct loading can be used to Single transformation where as indirect transformation can be used to multiple transformations or files In the direct we can perform recovery process but in Indirect we cant do it . Read More

Normalizer Read More

We can use do this by identifying the granularity of the target table . We can use CRC external procedure after that to compare newly generated CRC no. with the old one and if they do not match then update the row. Read More

This is type of active transformation which is responsible for sorting the data either in the ascending order or descending order according to the key specifier. the port on which the sorting takes place is called as sortkeyport properties if u... Read More

Data can be viewed using Informatica’s designer tool. If you want to view the data on source/target we can preview the data but with some limitations. We can use data profiling too. Read More

In the designer go to the main menu and one can see the export/import options. Import the exported mapping in to the production repository with replace options. Read More

If so, create the target with the name u have given in wizard for target(table). No’t create the target again for the second instance. It is just the virtual copy of the same target. i.e in warehouse designer create and execute the target... Read More

We use dynamic cache only for connected lookup. We use dynamic cache to check whether the record already exists in the target table are not. And depending on that, we insert,update or delete the records using update strategy. Static cache is the... Read More

Mainly there are two types of tranformation.1]Active TransformationAn active transformation can change the number of rows that pass through it from source to target i.e it eliminates rows that do not meet the condition in transformation.2]Passive... Read More

You can generate PowerCenter Metadata Reporter from a browser on any workstation, even a workstation that does not have PowerCenter tools installed. Read More

Use Sorter Transformation. When you configure the Sorter Transformation to treat output rows as distinct, it configures all ports as part of the sort key. It therefore discards duplicate rows compared during the sort operation Read More

Partitions are used to optimize the session performance we can select in sesstion propetys for partiotions types default----passthrough partition key range partion round robin partion hash partiotion Read More

You can overide the sql Query in Wofkflow Manager. LIke select * from tab_name where rownum<=1000 minus select * from tab_name where rownum<=500; This will work fine. Try it and get back to me if u have any issues about the same. Read More

Aggregate calculation like sum,avg,max,min these are the measure objetcs. Read More

Following are necessary 1.Power Connect license 2.Import the source and target from people soft using ODBC connections 3.Define connection under "Application Connection Browser" for the people soft source/target in workflow manager . select the... Read More

EDW is Enterprise Datawarehouse which means that its a centralised DW for the whole organization. this apporach is the apporach on Imon which relies on the point of having a single warehouse/centralised where the kimball apporach says to have... Read More

Open the browser, click the history button. Read More

You can not create or import flat file defintion in to warehouse designer directly.Instead you must analyze the file in source analyzer,then drag it into the warehouse designer. When you drag the flat file source defintion into warehouse desginer... Read More

You can join hetrogenious data sources in joiner transformation which we can not achieve in source qualifier transformation. You need matching keys to join two relational sources in source qualifier transformation.Where as you doesn?t need matching... Read More

It displays the updated information about the session in the monitor window. The monitor window displays the status of each session when you poll the informatica server. Read More

When you add a relational or a flat file source definition to a maping,U need to connect it to a source qualifer transformation.The source qualifier transformation represnets the records that the informatica server reads when it runs a session. Read More

COBOL files. Read More

A session can be scheduled to run at a given time or intervel,or u can manually run the session. Different options of scheduling Run only on demand: server runs the session only when user starts session explicitly Run once: Informatica server runs... Read More

Yes. By using copy session wizard You can copy a session in a different folder or repository. But that target folder or repository should consists of mapping of that session. If target folder or repository is not having the maping of copying session ... Read More

Two ways:- 1. Edit the definition 2. Reimport the defintion. Read More

Standalone repository. A repository that functions individually, unrelated and unconnected to other repositories. Global repository. (PowerCenter only.) The centralized repository in a domain, a group of connected repositories. Each domain can... Read More

views view is a combination of one or more table.view does not stores the data,it just store the query in file format.If we excutes the query the query will fetch the data from the tables and just make it to view for us. types views materilized... Read More

First of all stored procedures (at DB level) are series of SQL statement. And those are stored and compiled at the server side.In the Informatica it is a transformation that uses same stored procedures which are stored in the database. Stored... Read More

Mapping designer Tansformation developer Mapplet designer. Read More

Router transformation allows you to use a condition to test data. It is similar to filter transformation. It allows the testing to be done on one or more conditions. Read More

When using incremental aggregation, you apply captured changes in the source to aggregate calculations in a session. If the source changes only incrementally and you can capture changes, you can configure the session to process only those changes.... Read More

Noramally evey one use !)slowly changing diemnsions 2)slowly growing dimensions Read More

use a pre sql statement....but this is a hardcoding method...if you change the column names or put in extra columns in the flat file, you will have to change the insert statement Read More

In real time only star schema will implement because it will take less time and surrogate key will there in each and every dimension table in star schema and this surrogate key will assign as foreign key in fact table. Read More

Question : 1)What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA. 2) What are the common problems developers face while ETL... Read More

Question : Somebody ca explain me the 3 points:I want to Know : 1) the differences between using native and ODBC server-side databaseConnections 2)Know the reason why to register a server to the repository is necessary 3)Know the... Read More

Domain is nothing but give a comlete information on a particular subject area.. like sales domain,telecom domain..etc Read More

1.union & custom transformation 2.lookup on flatfile 3.we can use pmcmd command 4.we can export independent&dependent repository objects 5.version controlling 6.data proffiling 7.supporting of 64mb architecture 8.ldap authentication Read More

If we need to change certain attributes of a mapping after every time the session is run, it will be very difficult to edit the mapping and then change the attribute. So we use mapping parameters and variables and define the values in a parameter ... Read More

#include<iostream.h> void main() { int size; cout<<"Size "; cin>>size; int **p=new int *[size]; for(int i=0;i<size;i++) { p[i]=new int [size]; } for(i=0;i<size;i++) { for(int j=0;j<size;j++) { cin>>... Read More

Partition points mark the thread boundaries in a source pipeline and divide the pipeline into stages. Read More

foreign key Read More

The only two possibilities as of I know is Both the table should have primary key/foreign key relation ship Both the table should be available in the same schema or same database Read More

In session properties, There is an option insert update insert as update update as update like that by using this we will easily solve Read More

By using server manager or pmcmd. Read More

We can stop it using PMCMD command or in the monitor right click on that perticular session and select stop.this will stop the current session and the sessions next to it. Read More

Any number of sessions. Read More

Manages the session and batch scheduling: Whe you start the informatica server the load maneger launches and queries the repository for a list of sessions configured to run on the informatica server.When you configure the session the loadmanager... Read More

If you are having defined source you can use connected, source is not well defined or from different database you can go for unconnected We are using like that only Read More

The following is the query to find out the top three salaries in ORACLE:--(take emp table) select * from emp e where 3>(select count (*) from emp where e.sal>emp.sal) order by sal desc. in SQL Server:-(take emp table) select top 10 sal... Read More

It is a web based application that enables you to run reports againist repository metadata. With a meta data reporter,You can access information about U?r repository with out having knowledge of sql,transformation language or underlying tables in... Read More

Normal Load: Normal load will write information to the database log file so that if any recorvery is needed it is will be helpful. when the source file is a text file and loading data to a table,in such cases we should you normal load only, else the... Read More

Use lookup transformation in u?r mapping to lookup data in a relational table,view,synonym. Informatica server queries the look up table based on the lookup ports in the transformation.It compares the lookup transformation port values to lookup table... Read More

informatica server connects source data and target data using native odbc drivers again it connect to the repository for running sessions and retriveing metadata information source------>informatica server--------->target ... Read More

A transformation can reused, that is know as reusable transformation You can design using 2 methods using transformation developer create normal one and promote it to reusable Read More

This is used for finding source columns in workspace. Read More

It is a repostitory object that generates,modifies or passes data. Read More

Place it in local folder. Read More

Using it we can access the data from a relational table which is not a source in the mapping. For Ex:Suppose the source contains only Empno, but we want Empname also in the mapping.Then instead of adding another tbl which contains Empname as a... Read More

Static cache Dynamic cache U can not insert or update the cache U can insert rows into the cache as u pass to the target The informatic server returns a value from the lookup table or cache when the condition is true.When the condition is not... Read More

The data movement mode depends on whether Informatica Server should process single byte or multi-byte character data. This mode selection can affect the enforcement of code page relationships and code page validation in the Informatica Client and... Read More

Set of level properties that describe a specific aspect of a business, used for analyzing the factual measures of one or more cubes, which use that dimension. Egs. Geography, time, customer and product. Read More

Update Strategy is used to drive the data to be Inert, Update and Delete depending upon some condition. You can do this on session level tooo but there you cannot define any condition.For eg: If you want to doupdate and insert in one mapping...you... Read More

Simple Pass through Read More

NO. Informatica is not at all concern with back end data base.It displays u all the information that is to be stored in repository.If want to reflect back end changes to informatica screens, again u have to import from back end to informatica by... Read More

As explained above informatcia server has 3 methods to recovering the sessions.Use performing recovery to load the records from where the session fails. Read More

if u drag three hetrogenous sources and populated to target without any join means you are entertaining Carteisn product. If you don’t use join means not only diffrentsources but homegeous sources are show same error. If you are not... Read More

Following are the types of metadata that stores in the repository:- Database connections Global objects Mappings Mapplets Multidimensional metadata Reusable transformations Sessions and batches Short cuts Source definitions Target defintions... Read More

Ya its the level of information storage in session log. The option comes in the properties tab of transformations. By default it remains "Normal". Can be Verbose Initialisation Verbose Data Normal or Terse. Read More