Sim

• Feb 2nd, 2012

Measures are calculations based on facts. A measure points to a fact (such as order amount) and specifies an aggregation function (such as average or sum).

vizaik

 Profile Answers by vizaik Questions by vizaik

• Mar 26th, 2007

the real meaning of fact is what are all the necessary information for a business.Ex: in a business, customer,item,order,invoices tells information.calculation of amt to be paid by the customer is the...

Answer Question  Select Best Answer

vizaik

 Profile Answers by vizaik Questions by vizaik

• Mar 24th, 2007

Used in oracle to simplify queriesex: select rowid from (select ename from emp group by sal) where rowid<2

Hanu Ch Rao

• Feb 22nd, 2007

The inline view is a construct in Oracle SQL where you can place a query in the SQL FROM, clause, just as if the query was a table name.A common use for in-line views in Oracle SQL is to simplify complex queries by removing join operations and condensing several separate queries into a single query

Answer Question  Select Best Answer

narendraterainfo

 Profile Answers by narendraterainfo Questions by narendraterainfo

• Oct 14th, 2012

If the ETL is not ussing Full Pushdown optimization or Target Pushdown optimization . We can track with insert Time_stamp

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 9th, 2012

We can track the changes in SCD type 2 in many ways:

--> A time column
--> Mentioning a version

Answer Question  Select Best Answer

hemachandra

 Profile Answers by hemachandra Questions by hemachandra

• Dec 26th, 2007

Also you can use group by on all columns you are pulling either by sql override or aggrigator

hanug

 Profile Answers by hanug Questions by hanug

• May 8th, 2007

Use the sorter transformation and use "select distinct" property.Hanu.

Answer Question  Select Best Answer

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Mar 12th, 2007

First u can ask what type of data change columns to rows in informatica?Next we can use expression and aggregator transformation.aggregator is using group by duplicate rows

Hanu Ch Rao

• Mar 2nd, 2007

Hi,We can achieve this by Normalizer trans.

Answer Question  Select Best Answer

shravanamsharat

 Profile Answers by shravanamsharat Questions by shravanamsharat

• Mar 15th, 2007

Overwrite the SQL Query at Source Qualifier transformation

hemasundarnalco

 Profile Answers by hemasundarnalco Questions by hemasundarnalco

• Mar 9th, 2007

Write a sql qurey to perform an aggregation in the source qualifier transformation

Answer Question  Select Best Answer

1.How do you store Historical data in a DWH?2.What is the primary purpose of using surrogate key? Will those be used in fact tables?If not then what is the purpose in using it?3. How do you update Information in Update strategy Transformation?4. How do you validate data after you have transferred it into target table from flat files?

vizaik

 Profile Answers by vizaik Questions by vizaik

• Mar 15th, 2007

By using scd2, we can store historical data.Surrogate key is used for indexing purpose.  i.e. as a primary key for a table.  You can say that why can't we use primary key.  But the ...

vizaik

 Profile Answers by vizaik Questions by vizaik

• Mar 15th, 2007

By using scd2, we can store historical data.Surrogate key is used for indexing purpose.  i.e. as a primary key for a table.  You can say that why can't we use primary key.  But the ...

Answer Question  Select Best Answer

vivek1708

 Profile Answers by vivek1708 Questions by vivek1708

• Jul 30th, 2008

Specifying the number of test load rows in the session properties.

sreedhark26

 Profile Answers by sreedhark26 Questions by sreedhark26

• Mar 26th, 2007

HiU can test mapping in mapping Designer by using debugger. In Debugger u can test first instance and next instance. associated port is output port.sreedhar

Answer Question  Select Best Answer

The process of finding and removing or correcting data that is incorrect, out-of-date, redundant, incomplete, or formatted incorrectly.

sunil

• Aug 9th, 2006

it means    process of removing data inconsistancies and  reducing data in accuracies.

satyam

• Mar 13th, 2006

Data cleansing means remove the inconistance data and transfer the data correct way and correct manner

Answer Question  Select Best Answer

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