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

If there are 10000 records and while loading, if the session fails in between, how will you load the remaining data?

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 4th, 2010

With Incremental Aggregation.

reddykuruganti

 Profile Answers by reddykuruganti Questions by reddykuruganti

• Jun 7th, 2010

Simply you can restart the session, by selecting truncate table option in the session properties.

Answer Question  Select Best Answer

How to delete first 3 rows & last 3 rows in target table in Informatica?

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 28th, 2013

1. SQ 2. Expression --> Connect the expression with the Sequence Generator 3. Aggregator with one column(key column if any) Out_Count=count(*) Dummy_count=1 3. Expressio...

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Sep 3rd, 2012

Hi,

We can use a sql in the sql override:

select count(1) from
(select * from where rownum

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

Hi Folks,

I have scenario like, I have ten flat files to be loaded in to target but I need to load file names in to a table in mapping level. I think we can do achieve though TC transformation. Unfortunately I did not get though.. Please advise how to implement the logic. ( I need to capture in mapping level only).

This question has been asked one of the interviews.

BRAHMAIAH

 Profile Answers by BRAHMAIAH Questions by BRAHMAIAH

• Dec 30th, 2014

Hi folks, If all files have structure then we go for Indirect file method.we set this property at session level by selecting the source def. After define of the source def at mapping level just do...

Mayur

• Jun 23rd, 2014

Got to flat file properties and there you will find one icon Add FileName column to this table just click on that option and you can able to add currently processing file. Thank you

Answer Question  Select Best Answer

How to format phone number 9999999999 into (999)999-9999 in informatica

Vids

• Aug 13th, 2013

It can be achieved using the IDQ tool where u can set the standard format . EVen I am not sure how exactly

sreenu

• Dec 4th, 2011

Using the CONCAT (||) operator and SUBSTR function in the expression transformation.

Answer Question  Select Best Answer

Is it possible to use SCD Type-2 without using Lookup in the mapping?If it is possible please let me know. How it will be possible?

ashwin

• Mar 22nd, 2017

SRC-->SQ--> JNR-->EXP-->RTR-->TGT(Insert for both new and updated records) SRC(TGT)-->SQ--> -->TGT(Update The entire implementation will be same as that using a l...

ashwin

• Mar 22nd, 2017

The entire implementation will be same as that using a lookup. The only thing we need to replace the Lookup transformation with a Joiner transformation. In the Joiner transformation the Source table w...

Answer Question  Select Best Answer

Import flat file from the source (with nulls) it should display without null values in the target

laxmi

• Nov 10th, 2014

We can use validate record component with is_null() function.

sandeepsandeep

 Profile Answers by sandeepsandeep Questions by sandeepsandeep

• Aug 11th, 2014

After importing the flatfile, after the source qualifier use an expresssion transformation. In expression transformation use the condition IIF(column=NULL,0,Column)

(you can use either 0 or any other value u like..)

Answer Question  Select Best Answer

I have 1 crore record in my table and I have to load 25 Lakh in 1st target, 25L in 2nd target and 25L in 3rd target? How to load 1 crore records into 3 different targets having 25 L records in each?

vinit

• Jun 22nd, 2016

(SQ + Seq Gen) ---> Exp ---> sorter ----> router (having four groups for seq gen port) ---> four targets

Venkat

• Jun 13th, 2016

Pass Source qualifier to Expression Expression Condition Variable port(V_COUNT) - IIF(V_COUNT < = 75000,1,V_COUNT+1) O/P (Port segregation) - decode(true, V_COUNT < = 25000,1 ...

Answer Question  Select Best Answer

When U add a relational or a flat file source definition to a maping,U need to connect it to a source qualifer transformation.The source qualifier transformation represnets the records that the informatica server reads when it runs a session.

ASHOK1324

 Profile Answers by ASHOK1324 Questions by ASHOK1324

• Apr 21st, 2009

It is a transformation which is automatically generated to read the data from source tables into informatica designer.

jaber

 Profile Answers by jaber Questions by jaber

• Dec 9th, 2007

Source Qualifier is a transformation with every source definiton if the source is Relational Database.Source Qualifier fires a Select  statement on the source db.With every Source Definition...

Answer Question  Select Best Answer

Inner equi join.

Aaradhya

• Nov 10th, 2016

The Joiner transformation supports the following join types, which you set in the Properties tab: Normal (Default) Master Outer Detail Outer Full Outer Default join is Normal Join/Inner Join/Equi-Joi...

Vikas Dhakne

• Aug 8th, 2016

Source Qualifier transformation supports following types of joins:
1.Normal/Equi join
2.Left Outer Join
3.Right Outer Join

Answer Question  Select Best Answer

manoj_behera82

 Profile Answers by manoj_behera82 Questions by manoj_behera82

• Nov 9th, 2009

Basically source qualifier is a representation of the records that Informatica server reads when it runs the session. It is associated with a source can be a table or flat file as well. It is capable ...

divakar

• Nov 5th, 2007

A Source Qualifier transformation is the starting point in the mapping where in we are bringing the incoming data or the source data is extracted? from this? transformation after connecting to the?...

Answer Question  Select Best Answer

Naveen

• Nov 8th, 2012

Set source file type as INDIRECT

Amit Gaikwad

• Jul 26th, 2012

Step 1: Transfer all the 5 files on to your UNIX box or server from where you will fetch those 5 files Step 2: open notepad and type the 5 files name .ex:- a.csv ...

Answer Question  Select Best Answer

vikota

 Profile Answers by vikota Questions by vikota

• Apr 12th, 2011

Top-Down approach means first create the datawarehouse for entire organization then divide it into for each specific subject are called datamartsBottom-Up approach means first create the data marts then by combining all data marts create the datawarehouse

samirdesai999

 Profile Answers by samirdesai999 Questions by samirdesai999

• Jun 13th, 2009

Top Down-------------To build an mammoth enterprise data warehouse iteratively considering all enterprise needs and then feed individual departmental data marts.Bottom Up------------To build ...

Answer Question  Select Best Answer

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 14th, 2011

If both the tables are relational we can join both the tables using sql override but if one table is relational and another table is a flat then we've to use joiner transformation.

vikota

 Profile Answers by vikota Questions by vikota

• Apr 12th, 2011

If both the tables are available in same database by using source qualifier we can join i.e by using customized source qualifierif the tables are available in different database by using lookup we can join i.e one is source table and other is lookup table

Answer Question  Select Best Answer

Pawan Singh

• Jun 15th, 2013

This will add that value into previous one

MAHESH MANAM

• Aug 16th, 2012

We can but the results may change what you are expecting in output

Answer Question  Select Best Answer

1) what is the difference between power center and power mart?2) diff b/w versions of Informatica 5, 6 an d7?3) what is ODS?4) how to give mapping & session parameter in file?

pasupula.naidu

 Profile Answers by pasupula.naidu Questions by pasupula.naidu

• Dec 31st, 2010

For mapping parameters create a notepad file like this way, Sysntax:------------- [foldername.WF:workflow_name.ST:session_name] $$para_name=valuefor session parameters,sysnatx:-----------[...

hundwanipankaj

 Profile Answers by hundwanipankaj Questions by hundwanipankaj

• Apr 5th, 2010

Power Mart is a departmental version of Informatica for building, deploying, and managing data warehouses and data marts. Power center is used for corporate enterprise data warehouse and power mart is...

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

Use sorted input.

manoj_behera82

 Profile Answers by manoj_behera82 Questions by manoj_behera82

• Jul 20th, 2010

1. Provide sorted input into the aggregator. Do check the sorted input property in the aggregator.2. Reduce the input/output ports in the aggregator.3.Can try increasing the cache size.

job_infa

 Profile Answers by job_infa Questions by job_infa

• Jan 28th, 2009

-Use sorted input to decrease the use of aggregate caches.-Limit connected input/output or output ports.Limit the number of connected input/output or output ports to reduce the amount of data the Aggregator transformation stores in the data cache.-Filter the data before aggregating it.

Answer Question  Select Best Answer

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 10th, 2008

Surrogate key is know as datawarehouse key. Surrogate key is used as a unique key in warehouse where dupicate keys may exits due to type 2 changes.

shanthi1

 Profile Answers by shanthi1 Questions by shanthi1

• Mar 18th, 2007

There is a Dataware house key........plz go thru kimball bookEvery data warehouse key should be a surrogate key because the data warehouse DBA must have the flexibility to respond to changing descriptions and abnormal conditions in the raw data.

Answer Question  Select Best Answer