rakesh

• May 18th, 2012

TO_CHAR(DATE,MM) or
TO_CHAR(DATE,MON) or
TO_CHAR(DATE,FMMONTH)

mouni

• Apr 30th, 2012

Ex :to_char(trunc(sysdate),mm)
to_char(date,mm)

Answer Question  Select Best Answer

How do you handle error logic in Informatica? What are the transformations that you used while handling errors? How did you reload those error records in target?

Umesh

• May 14th, 2012

So we create 2 variable for every field on which we have to do error logging. 1 variable will check the condition for error (i.e. check for isnull or check for datatype) and assign NULL if it does not...

prashant.baranwal

 Profile Answers by prashant.baranwal Questions by prashant.baranwal

• Sep 11th, 2010

It is one of the most common concept which is being implement in alomost all DW projects. A very simple way of handing error and with their approprite messages is:Concat all the columns with a delimet...

Answer Question  Select Best Answer

What is performance tuning in informatica? How it can be done?

Raja Alluri

• May 13th, 2012

Looking at logs, we can identify which thread(Reader/ Writer/ Transformation) is taking time to process. Below are the options to improve performance: Mapping level changes--> 1. Move the filter T/f a...

kaliprasad

• Sep 28th, 2006

optimizing the session performance is known as performance tuning.the session runs in the availabale load window for the informatica server.performance tuning can be achieved in so many ways.1.use the...

Answer Question  Select Best Answer

I have two target tables,so i want to make Union of both the target,so please let me know about this

santanu

• May 11th, 2012

Make two flows in the same mapping:
flow 1: load both the targets
flow 2: use both the targets as the source and use SQL override to join the tables. Then load them into a single table

Sreedhar Lokaray

• Nov 3rd, 2011

I think your question is how to merge the records from two targets after they got loaded? If this is your question then first import the two target tables as source tables. Complete the mapping to loa...

Answer Question  Select Best Answer

How to solve pcsf_10342 when enabling integration service in Informatica 8.6.1 ?

Sudarshan

• May 2nd, 2012

Login to the admin console and delete the repository content and recreate it. Restart the integration service. It works!

Answer Question  Select Best Answer

How to call SQL stored procedures in Informatica?

kotireddy

• Apr 28th, 2012

Using Store Procedure t/r call it

Answer Question  Select Best Answer

Through one session how we load half of data from flat file on 1st run of session and on 2nd run of the same session it load rest half of data to the same target ?

Ankur Mishra

• Apr 26th, 2012

Create two session which points to the same mapping and parameterise the source qualifier query in a way that it picks first half record for the first session run and second half for the second sessio...

Answer Question  Select Best Answer

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file without adding extra columns?

ETLKaps

• Apr 10th, 2012

For the FlatFiles, in source definition, there is a option to include file name as one of the output port. There is no need to add FileName in actual source file. Informatica will append it to every r...

sridkaretl

 Profile Answers by sridkaretl Questions by sridkaretl

• Oct 21st, 2011

First thing i would like to know is whether the different targets are of same database or not. If the target is from same database then you can use router transformation by importing the flat file into source either as de-limited or fixed width.

Answer Question  Select Best Answer

Suhel Shaikh

• Apr 4th, 2012

There is no redo log file in informatica.Its in oracle.

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 5th, 2010

Redo log file stores the value only after the" Commit "Transaction Occurs

Answer Question  Select Best Answer

Q. How can you minimize the cache size for a Joiner transformation?
(A) Make the smaller source the master source.
(B) Make the smaller source the detail source.
(C) Sort the master data prior to the Joiner transformation.
(D) Sort the detail data prior to the Joiner transformation.

Munavar

• Mar 21st, 2012

A.Make the smaller source the master source.

Answer Question  Select Best Answer

What are the different tracing levels and how it is used?

Kiran_U

 Profile Answers by Kiran_U Questions by Kiran_U

• Feb 23rd, 2012

A Tracing level determines the amout of the information in the session log.or it store the information in session log. we have 4 types of Tracing levels 1.normal,2.verbose,3.verbose data,4.terse defa...

Answer Question  Select Best Answer

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