jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Jun 21st, 2012

Actually Sorter acts as both passive/Active if we check the Distinct Property then it acts as Active othewrwise passive

vishalkrishan

• Jun 19th, 2012

The Sorter transformation is an Active transformation because its attribute, Distinct provides a facility to remove duplicates from the input rows.

Answer Question  Select Best Answer

Is it possible that a Star Schema contains more than one fact tables? If Yes, How?

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Jun 21st, 2012

Yes we can logical fact in terms of obiee in star scema
and also with then help of Confirmed dimension we can have another fact in starschema

Rajesh

• Aug 1st, 2011

NO

Answer Question  Select Best Answer

Rajarao marisa

• May 31st, 2012

Ok its not good work environment by using multiple filter t/r usage Any way by using multiple filter we can load rejected rows also SD-->SQ-->fltr(condition(true)(eg:deptno=10)---->loaded into one tar...

srinuraj

 Profile Answers by srinuraj Questions by srinuraj

• May 31st, 2010

You can use filter transformations to filter rows. Filter transformations passes rows to next transformation which rows met the condition. But it cannot pass rows which rows doesn't meet the condition...

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

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

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

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

Hi all! I am a fresh graduate in Nigeria, looking forward to working with one of the big fours soon as a member of the IT advisory team, what IT tools would you advice I get acquainted with while I work towards my recruitment, secondly, can someone please enlighten me on the areas of ERP I need to take interest in, in order to perform on the job?

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 to find cumulative sum using JAVA Transformation?

Consider the following employees data as source

employee_id, salary
10, 1000
20, 2000
30, 3000
40, 5000

The target table data should look like as

employee_id, salary, cumulative_sum
10, 1000, 1000
20, 2000, 3000
30, 3000, 6000
40, 5000, 11000

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

Hi,

I have a requirement and I have created a mapping and I need to generate a single file based on location.

ex:
My server placed into us location and I will kick of my wf from uk so I need to create a uk file.

col1 col2 location
aaa bbb UK
xyz ccc UK

If I ran my wf from US location the out put file should be

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