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

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

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

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

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Jun 21st, 2012

By using BELOW SCENARIO we can do it the flow is like this
SRC-->SQ-->EXP-->T1
T2

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jun 11th, 2012

Hi Shiva,

You can use Normalizer t/f to achieve the desired output. There is an "Occur" option in Normalizer in which you can mention the no of times you want to load the same source data into target.

Answer Question  Select Best Answer

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Jun 21st, 2012

If the lookup source is same for all the lookups and if we are returning different columns for calculations then it is better to use unconnected lookup with expression instead of using connected lookup.

Utkarsh

• Mar 25th, 2012

1) Create Indexes on look up tables.
2) Try to use static cache instead of Dynamic cache.
3) Use Pushdown Optimization.

Answer Question  Select Best Answer

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 9th, 2012

Hi,

We can capture the delta changes by using a look up transformation followed by an update strategy transformation with which can insert,delete and update records.

Thanks.

Answer Question  Select Best Answer

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 9th, 2012

If we drop any sessions accidentally, it wont be deleted permanently until we do a check in. So if we want to recover the session, we can do a undo checkout on the session.

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Jun 1st, 2007

If you dropped your session or folder we can get it back if it has proper backup.we can also get it back when you have same folders in other environment, I mean to say, generally, we will have th...

Answer Question  Select Best Answer

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 9th, 2012

Hi, One way of getting only the duplicate columns loaded in the target table is to modify the SQ query: When primary keys are defined: select * from where exists (select PK1,PK2,... from group b...

koustav

• Jul 31st, 2007

I think you can write the sql query (delete from....) in session post-sql command and it will work good.

Answer Question  Select Best Answer

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Jul 11th, 2012

When an Aggregator transformation is used without sorter, it stores all the data before performing the grouping operation. But when a sorter is used before aggregator, it sorts all the data before pas...

sai

• Feb 14th, 2007

passing data to sorter is time taking why because sorter transf stores whole data in buffer and then sorts based in specified ports.insted of passing data to sorter transf ,sort d data in the sours...

Answer Question  Select Best Answer

What is the structure of the reject file in Informatica?

Ramarao

• Jul 10th, 2012

We need to give the option in target level for rejected data (means needs to give the path of the badfiles to capture the rejected data)

Kiran

• Apr 15th, 2012

There is no predefined structure for bad files. It has the same structure as of the target table.

Answer Question  Select Best Answer

jyothi

• Jul 24th, 2012

service oriented Architecture,Pushdown Optimization,sql t/r is added,java t/r is add

prashant

• Sep 3rd, 2011

Main difference between informatica 7.x and 8.x are:-

1. Java transformation is introduced in Informatica 8.x. while was not in 7.x

2.and Power exchange tool also introduced in informatica 8.x while was not in 7.x

Answer Question  Select Best Answer

Amit Gaikwad

• Jul 26th, 2012

Step 1: Go to session , and in treat source rows as :UPDATE
step2: in target table option select INSERT and UPDATE ELSE INSERT :)
Step 3:Refresh and Run the session .

nagadurgaraju

 Profile Answers by nagadurgaraju Questions by nagadurgaraju

• Sep 1st, 2010

By using source qualifier transformation to update tha target table,through SQL overriding...

Answer Question  Select Best Answer

If there are multiple source flat files with different names but same file structure. How do we load all those files to the target in one step?

Read Best Answer

Editorial / Best Answer

etluser  

 Profile Answers by etluser Questions by etluser

• Member Since Dec-2009 | Dec 31st, 2009

---

Follow the below steps-
1. Create the mapping as if there is only single source and target.
2. Now create an additional file on the server which will list the multiple source file names along with their paths.
3. Specify the path and name of this file in the "Source File" under session properties. 
4. Now the most important thing - Set "Source Filetype" as "indirect" under session properties.

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 3rd, 2012

There is a concept of Indirect filelist for processing multiple files with similar structure.

Rajath

• Feb 20th, 2012

What if there are n source files(number may vary) with the same structure? File name maybe similar for e.g. TxtFile_1,TxtFile_2,TxtFile_3...........TxtFile_n

Improve Answer

I have 2 sources one is relational table with 7 ports
second is flat file with 8 ports.How can I get the combined output and I should not do any modifications to the source structure?

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 3rd, 2012

Hi, I think we can obtain the results by using Joiner transformation. If the sources have no common columns, we can add one extra column with a value 1 in both the sources and then can join based on ...

Answer Question  Select Best Answer

MAHESH MANAM

• Aug 16th, 2012

From flat file you use the following wys: --> In source analyzer you can create file by manually -->you can import file -->you can use any of the flat file and give session properties in that correc...

dileep671

 Profile Answers by dileep671 Questions by dileep671

• Aug 3rd, 2012

Go to Source analyzer , then import XML Source, a wizard opens up.. select the Schema Definition (XSD) of th XML file

When you run the session, give the XML file name and XML file directory path.

Answer Question  Select Best Answer