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

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

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

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

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

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

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

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

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

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

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 to call SQL stored procedures in Informatica?

kotireddy

• Apr 28th, 2012

Using Store Procedure t/r call it

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

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

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

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

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

If the records are transfered from Source to target and if you want to check whether all the records are stored in the target. What are the possible ways to check that.

Rishak

 Profile Answers by Rishak Questions by Rishak

• May 21st, 2012

If you want to check the records,you can directly use MINUS query for eg

Code
 

Hope this will help Thanks Risha

skaur29

 Profile Answers by skaur29 Questions by skaur29

• Nov 17th, 2011

1) Check Session Logs
2) Use Preview Data option for Target in PowerCenter once session is completed
3) Sql queries if it is a Relational database

Answer Question  Select Best Answer

Hi all

I have been ETL informatica Developer for last few years.I am good at SQL and Unix.I need some guidance for my career.I wanna learn BO or any other reporting tool along with ETL.I wanna learn anything more which could help my career .I just some guidance from all of you.Please help.

Thank You
Prithvi

Anil Borru

• May 28th, 2012

My suggestion is ETL tools having lot of demand in Market so better don't change path and try to learn Datastage or another ETL tools.

Answer Question  Select Best Answer

Hi All,
I have oracle data source table and flat file target, now I want load data from oracle table source to flat file? How can I do? Which tranformation needs to this one? Please give solution with steps.

Thanks in advance.

lakshmi

• May 27th, 2012

Source--->sqt/r--->Target
In session level(advanced file properties) u have to set some of the properties like output type,directory, filename and codepage type.

Answer Question  Select Best Answer