vivek1708

 Profile Answers by vivek1708 Questions by vivek1708

• Jul 30th, 2008

Junk dimensions are particularly useful in Snowflake schema and one of the reasons why snowfalke is preferred over the star schema.There are dimensions that are frequently updated. So from the base se...

ravi kumar guturi

• Mar 10th, 2006

A junk dimension is a used for constrain queary purpose based on text and flag values.Some times a few dimensions discarded in a major dimensions , That time we kept in to one place the all discarded dimensions that is called junk dimensions.

Answer Question  Select Best Answer

hima

• Sep 26th, 2011

Detailed filter is used before an aggregator transformation .

Summarised filter? One used after the aggregator transformation

Amiyangshu Pal

• Aug 17th, 2006

Will it be correct to say that Summary Filter ----> HAVING Clause in SQLDetails Filter ------> WHERE Clause in SQL

Answer Question  Select Best Answer

suhas

• May 19th, 2006

You can use the Expression transformation to calculate values in a single row before you write to the target. For example, you might need to adjust employee salaries, concatenate first and last names, or convert strings to numbers.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 9th, 2006

Expression finds the Primary key is or not, and calculates new flagBased on that New Flag, filter transformation filters the DataCheers,Sithu

Answer Question  Select Best Answer

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 4th, 2006

Informatica Server Object is must.Cheers,Sithu

reddeppa

• Jan 1st, 2006

Informatica server must run,,

Answer Question  Select Best Answer

Vaishali

• Jun 25th, 2007

Decode can be used in select statement whereas IIF cannot be used.

raj

• Dec 27th, 2005

U can use decode in conditioning coloumns also while we cann't use iff but u can use case. but by using decode retrieveing data is quick  

Answer Question  Select Best Answer

raja rajan

• Feb 7th, 2006

During the execution of workflow all the rejected rows will be stored in bad files(where your informatica server get installed;C:\Program Files\Informatica PowerC...

jawahar

• Jan 30th, 2006

can  you explain how to load rejected rows thro informatica

Answer Question  Select Best Answer

prasadns26

 Profile Answers by prasadns26 Questions by prasadns26

• Jul 18th, 2006

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

gauravkant

 Profile Answers by gauravkant Questions by gauravkant

• Feb 13th, 2006

You can handle that by simply using the source analyzer window and then go to the ports of that flat file representations and changing the precision and scales.

Answer Question  Select Best Answer

dashingcar

 Profile Answers by dashingcar Questions by dashingcar

• Apr 19th, 2010

PowerCenter 8.1.1 Performance Tuning Guide Generally, look for performance bottlenecks in the following order: 1. Target 2. Source 3. Mapping 4. Session 5. System Use the following methods to identify...

rajendar

• Feb 12th, 2006

work flow may be slow due to different reasons one is alpa characters in decimal data check it out this and due to insufficient length of strings check with the sql override

Answer Question  Select Best Answer

kalyan

• May 1st, 2006

Stop: In this case data query from source databases is stopped immediately but whatever data has been loaded into buffer, there transformations and loading contunes. Abort: Same as Stop but in this case maximum time allowed for buffered data is 60 Seconds.

kalyan

• May 1st, 2006

Stop: In this case data query from source databases is stopped immediately but whatever data has been loaded into buffer, there transformations and loading contunes.Abort: Same as Stop but in this case maximum time allowed for buffered data is 60 Seconds.

Answer Question  Select Best Answer

There is a source table in MS-Access within that a column order_date is available. How to create a TIME DIMENSION in the Target Database(Oracle)?

arun.menon

 Profile Answers by arun.menon Questions by arun.menon

• Oct 24th, 2008

Time and Date dimensions are static dimension. Those are one time activity to populate these tables. It is just the naming convetion used across the projects. If you observe these tables, it will have...

Motilal

• Jun 30th, 2006

Hi Jagadeesh,Can you please mail me with the answer of calling the stored procedure for time dimension.And can have the procedure for time dimension in Oracle..?

Answer Question  Select Best Answer

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 13th, 2011

Look up transformation helps us to look for a data in a flat file,relational,view synonym. Lookup transformation can be used to get a related value and in a slowly changing dimensions Update strategy...

Kathir

• Oct 6th, 2006

In Lookup transformation the source table look to the other tables what the destination you needBut in update stratergy you required empty field you have to fill it

Answer Question  Select Best Answer

shyamjamisetty

 Profile Answers by shyamjamisetty Questions by shyamjamisetty

• Mar 22nd, 2008

u mean only look up trf and not any other transformations? be clear? if not one senario is that , we can use multiple connected loopup trf ,depending upon the target.if u have different wh_keys in ur ...

Neha

• Apr 3rd, 2006

Use unconnected lookup if same lookup repeats multiple times.

Answer Question  Select Best Answer

Abhik

• Sep 21st, 2006

In Database parlance you can define a domain " a set of all possible permissible values for any attribute".Like you can say the domain for attribute "Credit Card No#" consists of all possible valid 16 digit numbers.Thanks.  

Ashish

• Jul 28th, 2006

Domain in Informatica means - A central Global repository (GDR) along with the registered Local repositories (LDR) to this GDR. This is possible only in PowerCenter and not PowerMart.

Answer Question  Select Best Answer

What is the impact of turning versioning on or off for an Informatica repository? What is the impact of versioning on an existing repository and the new repository, when adding a new repository to the repository server?Thanks, Deborah

adilshariff

 Profile Answers by adilshariff Questions by adilshariff

• Jul 1st, 2008

1.Versioning is a one time and one way process on Informatica repository.2.No impact on both the exisitng and new reprository.Infact Versioning is advantage,it is help full in team based  envirno...

Uma Bojja

• Aug 14th, 2007

Versioning on repository is irreversible. Once we choose to version its done.Let me know which version of informatica are you using.ThanksUma Bojja

Answer Question  Select Best Answer

svivekananda

 Profile Answers by svivekananda Questions by svivekananda

• Jul 9th, 2010

1. check in session log + monitor output if the run is successful2. open the target and check the data manually

Prasad

• Jul 14th, 2006

Hi,If you want to know the performance of a mapping at transformation level, then select the option in the session properties-> collect performance data. At the run time in the monitor you can see it ...

Answer Question  Select Best Answer

vikki_gupta2003

 Profile Answers by vikki_gupta2003 Questions by vikki_gupta2003

• Mar 14th, 2007

Hi,1)At DB level we can simply DROP the stagin table.2)then Create Target table at DB level.3) Directly LOAD the records into target table.NOTE: It is recommended to use staging area.

Prasad

• Jul 14th, 2006

hi,this question is logically not correct. staging area is just a set of intermediate tables.u can create or maintain these tables in the same database as of ur DWH or in a different DB.These tables w...

Answer Question  Select Best Answer

naga

• May 24th, 2007

In realtime star schema is the better one. Surrogate key is linked to the lowest level. For example?country, state, city, area in this surrogate key is with 'AREA'

shaik

• Jun 27th, 2006

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.

Answer Question  Select Best Answer

Prasad

• Jul 14th, 2006

what ever is said above is correct. Just add 2 dummy ports in the joiner transformation with the same datatypes(Integer). one dummy port as detail and other as master.Then assign both the ports d...

kumar

• Jun 11th, 2006

Could you please briefly explain on this?

Answer Question  Select Best Answer

madhu

• Sep 23rd, 2006

hi nimmi please explain me regarding complete partition. I need clear picture. what tranmission it will ristrict, how it will ristric , where we have to give. thanksmadhu.

nimmi

• Aug 21st, 2006

HiIn informatica we can tune performance in 5 different levels that is at source level,target level,mapping level,session level and at network level.So to tune the performance at session level we go f...

Answer Question  Select Best Answer

what are all the modes are available for running a session.Can any one Explain in Detail?

Kishan

• Dec 6th, 2006

thq for ur reply....cud plz tell me wher we can use this stored procedure transforamtion,update strategy trnasformation with ex:..waits for ur reply 

UmaBojja

• May 26th, 2006

If u are asking about the mode in which the data is transferred then Informatica supports two modes1.ASCII2.UNICODE

Answer Question  Select Best Answer