sriinivas kasiboina

• Feb 15th, 2012

SCD Type 3 is used when it is necessary for datawarehouse to keep track of historical changes and when such changes will only for finite number of times.

sriram

• Sep 27th, 2011

Scd type3 is used for loading the current & most previous data into target

Answer Question  Select Best Answer

If incremental aggregation option is checked in session properties will the new cache is created during every run?

Thara Shri

• Feb 10th, 2012

Incremental aggregation creates a cache memory in the first run, in each successive runs, the cache is updated with new records( apart from the old records). Same cache but updated records. So you ha...

Answer Question  Select Best Answer

What is Subject Area?

P.ChinaMastan Vali

• Feb 9th, 2012

May be 18 transformations are there in Informatica. They are source qualifier, sorter, filter, router, aggregator, expression, update strategy, store procedure, sequence generator, external procedure,...

surendra

• Oct 11th, 2011

I think this is obiee question anyway , subject area is a presentation service equivalent to presentation catalog in bi server .

Answer Question  Select Best Answer

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

kmahidar

 Profile Answers by kmahidar Questions by kmahidar

• Jan 30th, 2012

Create a variable port : v_cume_sal=v_cume_sal+amt
output port : o_cume_sal=v_cume_sal

kmahidar

 Profile Answers by kmahidar Questions by kmahidar

• Jan 30th, 2012

In Expression t/r
Create one variable Port v_cum_sal=v_cuma_sal+sal
output port o_cum_sal=v_cum_sal

Answer Question  Select Best Answer

KRISHNAREDDY

• Jan 27th, 2012

BY USING LOOKUP T/R WE CAN JOIN NON EQUI JOINS

latha.c

 Profile Answers by latha.c Questions by latha.c

• Apr 20th, 2010

Non Equi Join is same as outer join in join transformation. So we can do by using the joiner in Informatica.

Answer Question  Select Best Answer

Rambabu

• Jan 17th, 2012

Yes we can do it

Shravani

• Jan 13th, 2012

Yes we can.

Answer Question  Select Best Answer

How to load source into target 2 times?

rangarao.dwh

 Profile Answers by rangarao.dwh Questions by rangarao.dwh

• Jan 9th, 2012

For this Question I can provide four answers
1. By using union Transformation
2. Connect target two times to two source
3. By using Target load plan
4. By using Java transformation

Note: All of the methods works only when the target having no Primary key or Unique Key.

sridkaretl

 Profile Answers by sridkaretl Questions by sridkaretl

• Oct 21st, 2011

hi, we cannot use router transformation because router transformation is condition dependent and data is stored into multiple target. For using push-down optimization(Source-Qualifier) data is stored...

Answer Question  Select Best Answer

Which functions are used in Union Transformation?

rangarao.dwh

 Profile Answers by rangarao.dwh Questions by rangarao.dwh

• Jan 9th, 2012

Union Transformation works like as Union All in SQl and in this transformation we cant use any external functions like avaliable in expersion editor means which is specially designed for joining the records vertically.

sridkaretl

 Profile Answers by sridkaretl Questions by sridkaretl

• Oct 21st, 2011

i didnt understand the question. First, a union transformation is active transformation which is used to combine data from multiple sources into single target. This union transformation supports union...

Answer Question  Select Best Answer

Santosh

• Dec 26th, 2011

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

suren

• Nov 22nd, 2011

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

Answer Question  Select Best Answer

What is the difference between index cache and data cache

santosh

• Dec 26th, 2011

Index cache : Integration service stores all conditional values in to the index cache and all output values into the data cache.

Please correct me anything wrong

skaur29

 Profile Answers by skaur29 Questions by skaur29

• Nov 17th, 2011

If we talk with respect to Aggregate Transformation , then Index Cache stores the Group Values and data Cache stores the Actual Data which is Row data.

Answer Question  Select Best Answer

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Dec 20th, 2011

In Stored Procedure transformation we can also specify when the SP should run.Its Normal,Pre-load of the Source,Post-load of the Source,Pre-load of the Target and Post-load of the Target. Pre-load of...

Anubhav Raikar

• Nov 15th, 2011

If you are asking this in terms of Stored Procedure Transformation, then the SP would be run before the Source fetches any data (in case you select Source PreLoad) .. and in case of Source PostLoad th...

Answer Question  Select Best Answer

venkat

• Dec 14th, 2011

In the look up properties whenever you check the dynamic lookup cache is enable, in lookup table new column is added automatically that is newlooup port. If the new lookup port is 0 then there is no change. If it is 1 insert and if it is 2 update.

srikanth

• Nov 18th, 2011

How to get total as new row and sum as 10.000

Code
 

Answer Question  Select Best Answer

I am unable to start my Informatica Repository Service, Even if I start the service, it stops immediately.Please, any one have a solution to this problem(I installed Informatica 7.1 on WINDOWS XP Home Edition, Oracle 10g)Thanks a lot.nagesh

k.praveenkumar

• Dec 6th, 2011

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

Srikanta

• Nov 11th, 2011

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

Answer Question  Select Best Answer

Suppose in my mapping 3 pipelines are there from source to target and i want to run the middle pipeline only.

Suhel Shaikh

• Nov 24th, 2011

Example; If we have two pipelines in a single mapping then whichever pipeline you do want to run just add 1=2 in the SQ override as a last statement.And create two sessions for the same mapping and add this statement to the SQ of one source which you don't want to run.It will run the other one.

SEHAJ SHANGARI

• Aug 18th, 2011

In designer.
Select mapping tab
There is a property target load plan
Select the source qualifier and the target which u want to run the first n place it in first position. Followed by other pipelines

Answer Question  Select Best Answer

I need to comment the stored procedure in the mapping

sreenu

• Nov 19th, 2011

Pass dummy argument and do not connect the output of the stored procedure to actual fields.. you this as pass through transformation if it is a connected one

if it is unconnected t/f then you can simply ignore the output of the field in the expression

Answer Question  Select Best Answer

While reading flat files can we increase the default size of 1024 bytes of a line?If yes then is there any upper limit for that?

Sreenu

• Nov 19th, 2011

Yes, we can increase the line sequential buffer length in the session properties.

There is no hard limit actually, but when the block size and the DTM buffer size also should be increased to be able to process the records

Answer Question  Select Best Answer

please explain working with transactions in joiner transformations. What conditions are set. And any scenarios where it is used.

Sreenu

• Nov 19th, 2011

Please get this information from the Informatica help file( no one can give better than in help)

Let us if you are looking for the answer on any specific requirement

Answer Question  Select Best Answer

What are few real time issues or problems while doing Informatica project. As a Informatica ETL developer, what will be the daily tasks or work.

sreenu

• Nov 19th, 2011

Actually it depends on the projects...

Anyway you will see the below issues in general

1. some specific characters are not loading as in the source
2. Data truncation happened on few fields
3. Frequent changes are coming from the user
4. Performance issues when loading huge data

Answer Question  Select Best Answer

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

KOTI

• Oct 31st, 2011

First find out the problem whether it is due to aggregator transformation or not. Run debugging...

sivakp

 Profile Answers by sivakp Questions by sivakp

• Mar 13th, 2011

You can use incremental aggrigation.

Answer Question  Select Best Answer