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

chandrarekha

• Sep 12th, 2007

Update strategy transformation is used for flagging the records for insert, update, delete and reject In Informatica power center u can develop update strategy at two levels use update strategy T/...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

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

Answer Question  Select Best Answer

Data driven.

kvrp461

 Profile Answers by kvrp461 Questions by kvrp461

• Aug 19th, 2010

Dd_insert or 0(zero)

Gyaneshwar

• Mar 28th, 2006

DATA DRIVEN

Answer Question  Select Best Answer

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

ankita

• Oct 1st, 2018

Truncate table

Prasanna

• Feb 3rd, 2006

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

Answer Question  Select Best Answer

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 Wizard. Creates mappings to load static fact and dimension tables, as well as slowly growing dimension tables. Slowly Changing Dimensions Wizard. Creates...

raj

• Apr 13th, 2007

Inf designer :Mapping ->  wizards -->  1) Getting started -->Simple pass through mapping               &nb...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 9th, 2006

Simple Pass through Slowly Growing Target Slowly Changing the Dimension Type1Most recent values Type2Full HistoryVersionFlagDate Type3Current and one previous

Answer Question  Select Best Answer

Any number of sessions.

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 12th, 2011

No limit

Syed Muzaffer Uddin

 Profile Answers by Syed Muzaffer Uddin Questions by Syed Muzaffer Uddin

• Jun 22nd, 2011

Any number of session can be created in the batch, but the best practice is to have less number of tasks, it will help at the time of migration.

Answer Question  Select Best Answer

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 variables that r created in a reusable transformation can be usefull in any other maping or maplet. We can not include source definitions in reusable transformations.But...

siraj khan

• Aug 6th, 2007

Mapplet is a group of reusable transformation.The main purpose of using Mapplet is  to hide the logic from end user point of view...It works like a function in C language.We can use it N number of times.Its a reusable object.Reusable transformation is a single transformation.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

Maplet: one or more transformationsReusable transformation: only one transformation Cheers,Sithu

Answer Question  Select Best Answer

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 when you want the Informatica Server to perform the transformations, and connect strings for sources and targets. The repository also stores administrative...

kiranbabu.jaladi

• Sep 7th, 2011

It is an RDBMS.
It keeps metadata. (information about tha data)
It keeps only logical informatoin. No physical data inside the repository.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 10th, 2006

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

Answer Question  Select Best Answer

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 valid connection.And u have to replace the existing files with imported files.

Tapas

• Oct 6th, 2007

It does matter if you have SQL override - say in the SQ or in a Lookup, you override the default sql. Then if you make a change to the underlying table in the database that makes the override SQL inco...

vidyanand

• Aug 4th, 2006

Yes, It will be reflected once u refresh the mapping once again.

Answer Question  Select Best Answer

Lenin

• Nov 2nd, 2005

A TIME DIMENSION is a table that contains the detail information of the time at which a particular 'transaction' or 'sale' (event) has taken place. The TIME DIMENSION has the details of DAY, WEEK, MONTH, QUARTER, YEAR

prasad nallapati

• Aug 25th, 2005

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

Answer Question  Select Best Answer

sm1506

• Apr 8th, 2006

vamshidhar,How do u convert rows to columns in Normalizer? could you explain us??Normally, its used to convert columns to rows but for converting rows to columns, we need an aggregator and expression ...

Vamshidhar

• Jan 11th, 2006

Hi,By using Normalizer transformation we can conver rows into columns and columns into rows and also we can collect multile rows from one row

Answer Question  Select Best Answer

halgai

 Profile Answers by halgai Questions by halgai

• Oct 8th, 2007

Design a trap to a file or table by the use of a filter transformation or a router transformation. Router works well for this.

ravi kumar guturi

• Oct 5th, 2005

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.

Answer Question  Select Best Answer

siraj.khan

• Aug 3rd, 2007

No it's not possible. source qualifier don't have any variables fields to utilize as expression.

premlahari

 Profile Answers by premlahari Questions by premlahari

• Dec 13th, 2005

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 feilds to utalize as expression.

Answer Question  Select Best Answer

Azhar

• Mar 30th, 2006

Can someone guide me on1) Data profiling.2) Exporting independent and dependent objects.Thanks in advance.-Azhar

Rama

• Nov 28th, 2005

Features in 7.1 are :1.union and custom transformation2.lookup on flat file3.grid servers working on different operating systems can coexist on same server4.we can use pmcmdrep5.we can export independ...

Answer Question  Select Best Answer

Powercenter server contains the sheduled runs at which time data should load from source to target Repository contains all the definitions of the mappings done in designer.

na123

 Profile Answers by na123 Questions by na123

• Aug 22nd, 2006

power center server-power center server does the extraction from the source and loaded it to the target.repository server-it takes care of the connection between the power center client and repository...

Guest

• Jul 18th, 2006

hi,Repository is nothing but a set of tables created in a DB.it stores all metadata of the infa objects.Repository server is one which communicates with the repository i.e DB. all the metadata is retr...

Answer Question  Select Best Answer

Client having database throught that data base u get all sources

kishore

• Jan 29th, 2006

creating of staging tables/area is the work of data modellor/dba.just like  " create table ......"  the tables will be created. they will have some name to identified as staging like  dwc_tmp_asset_eval.tmp-----> indicate temparary tables nothing but staging

Gokulnath_J

 Profile Answers by Gokulnath_J Questions by Gokulnath_J

• Nov 8th, 2005

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

Answer Question  Select Best Answer

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

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

sri

• Nov 29th, 2005

Hi manoj,I appreciate ur response ,But can u be a bit clearthankssri

Answer Question  Select Best Answer

Jose

• Jan 27th, 2014

By default the maximum concurrent session is 10 and during installation we are setting the number of concurrent session.

prasadns26

 Profile Answers by prasadns26 Questions by prasadns26

• Jul 18th, 2006

hi,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.

Answer Question  Select Best Answer

reddeppa

• Jan 1st, 2006

there is one formula..no.of bloccks=0.9*( DTM buffer size/block size)*no.of partitions.here no.of blocks=(source+targets)*2

pat

• Dec 7th, 2005

The restriction is only on the database side. how many concurrent threads r u allowed to run on the db server?

Answer Question  Select Best Answer

krishnasri424

 Profile Answers by krishnasri424 Questions by krishnasri424

• Dec 7th, 2006

Use sequence generator and set the 'Increment by' property in that with 2.

Pavan.m

• Dec 7th, 2006

Use sequence generator to generate warehouse keys and set the 'Increment by ' property of sequence genrator to 2.

Answer Question  Select Best Answer

deepika

• Nov 7th, 2006

Hi sunil,I got a problem with this...Can you jsut tell me a procedure to generate sequence number in SQl  like...if i give n no of emplyees it should generate seq.and i want to use them in informatica...using stored procedure and load them into target..can u help me with this..thanks

sunil kumar

• Feb 15th, 2006

CREATE ONE PROCEDURE AND DECLARE THE SEQUENCE INSIDE THE PROCEDURE,FINALLY CALL THE PROCEDURE IN INFORMATICA WITH THE HELP OF STORED PROCEDURE TRANSFORMATION.if still is there any problem please contact me.Thanks Good Luck!

Answer Question  Select Best Answer