Series: Subject: Topic:

Informatica Interview Questions

Showing Questions 1 - 20 of 1131 Questions
First | Prev | | Next | Last Page
Sort by: 

If session fails after loading 100 record and want to load 300 to 500 records in Informatica.

Asked By: hanuma | Asked On: Jul 7th, 2014

Answered by: Gayathri on: Jul 21st, 2014

Go to Session Properties->Config.Object, Make Stop on Error as 0.
This will not fail the session if there is error in 1 record. This will load all error free records.

Answered by: Dinesh on: Jul 20th, 2014

If the source is FF, then use skip first 299 rows and then start loading.

If the source is relational then u row number.

How to remove the null values in flat file ?

Asked By: madhulatha | Asked On: Jul 8th, 2014

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

Answered by: poovendhiran on: Jul 16th, 2014

Can we use condition like "not isnull(column name)" in filter transformation and make downstream connection

Answered by: Abhinav on: Jul 14th, 2014

I guess you can handle this situation inside Expression T/R and pass non NULL rows.

Can we revert back reusable transformation to normal transformation?

Asked By: anil | Asked On: Nov 9th, 2006

Answered by: venkat2ram on: Jul 14th, 2014

Yes, We can!

Open the folder where the reusable transformation is existing.

Then open mapping designer then drag the reusable transformation to mapping designer area. Now hold the Ctrl key and drop it.

Now you have non reusable version of your reusable transformation.


Answered by: Bibhu on: Jul 4th, 2014

Yes, we can. It can be done in the transformation developer.

Informatica scenerios

Asked By: Madhuri Manchiraju | Asked On: Jul 1st, 2014

Which means the first record should come as last record and last record should come as first record and load into the target file?

Answered by: venkat2ram on: Jul 14th, 2014

This is pretty simple.

Use sequence generator to number the records.

Then sort them in descending order using sorter transformation.

Etl transformation question

Asked By: madhulatha | Asked On: Jul 8th, 2014

Employee name start with a pass to one target,employee name start with s pass to 2nd target,employee name start with j pass to 3rd target,other pass to other target.

Answered by: Abhinav on: Jul 14th, 2014

You Can use INSTR function inside expression T/R and find the respective characters and raise a subsequent flag for Each Characters.Use Router T/R to send these records to multiple targets.

Answered by: Digvijay on: Jul 13th, 2014

Use a Router transformation and create 3 groups with condition as Group_A : UPPER(SUBSTR(First_Name,1,1))=A Group_S : UPPER(SUBSTR(First_Name,1,1))=S Group_J : UPPER(SUBSTR(First_Name,1,1))=J Others...

How do you evaluate the performance of powercenter mapping with 10 records ?

Asked By: dhinesh | Asked On: Nov 1st, 2011

Answered by: ash.singh1790 on: Jul 13th, 2014

1. Session Properties
2. Under General Options ---> Check "Enable Test Load" ---> Insert 10 in "Number of rows to test"

Answered by: Mayur on: Jun 19th, 2014

In Session property we have one option that is Performance data check, if you click that option you it will give transformation wise result.

How to load data from excel to database using Informatica

Asked By: kotasr | Asked On: Dec 4th, 2007

Hi,i am just wondering if there is a direct way to load excel file into database using Informatica without having to convert excel to .Csv or XML format. Because we may have to load data from different excel worksheets.Thanks in advancesrini

Answered by: Sreedhar Lokaray on: Jul 11th, 2014

We have a separate client tool in Informatica called B2BDT. Earlier it was called as Complex Data Exchange. This tool is used to read data from different sheets of an xls. Not only xls it can be used to read data from pdf, word docs etc.

Answered by: Manohara Devara on: Jul 3rd, 2012

Go to source and create required ports and send to Expression..there we need to converted the delimiter file or Comma separate file by using the ltrime and rtrime values...and send to target ....

Which transformation should we use to normalize the cobol and relational sources?

Asked By: Interview Candidate | Asked On: Sep 21st, 2004

Normalizer transformation. When u drag the cobol source in to the mapping designer workspace,the normalizer transformation automatically appears,creating input and output ports for every column in the source.

Answered by: Ramesh Reddy on: Jul 7th, 2014

This is a type an active transformation which allows to read the cobal files....
the cobal source definition associated with normalized transformation....
Use Normalizer T/R to perform data pivote.. the data pivote is a process of converting a single input record into Multiple output records.....

Answered by: sithusithu on: Jan 19th, 2006

The Normalizer transformation normalizes records from COBOL and relational sources, allowing you to organize the data according to your own needs. A Normalizer transformation can appear anywhere in a ...

Suppose I have one source which is linked into 3 targets.When the workflow runs for the first time only the first target should be populated and the rest two(second and last) should not be populated.When...

Asked By: Thiyagarajan | Asked On: Nov 7th, 2006

Answered by: rohit on: Jul 4th, 2014

Hi You can use the Seq generator and opt for the cyclle option,increment it by one by giving the start value also as one.Then connect the next val port to a expression and then to a router .In router ...

Answered by: Pawan Singh on: Jun 14th, 2013

define one parameter with name $$Target_LOAD in parameter file and use that variable in the expression transformation with Target_load, after expression use router transformation , in Router create th...

How do you migrate from one environment to another like development to production in Informatica. Which files do you move?

Asked By: ebrahim | Asked On: Apr 18th, 2007

Answered by: Mushi on: Jun 30th, 2014

First - Take a backup and restore of the repository using the Informatica Repository Manager console. Migration can be done at 3 levels: 1.Repository level , 2.Folder level , 3.Object level Steps fo...

Answered by: Tapas on: Oct 6th, 2007

1. Export repository and import into the new environment2. Use informatica deployment groups3. Copy folders/objects4. Export each mapping to xml and import in new environment

How to remove 2 starting rows from my source flat flie

Asked By: jeelan.shah | Asked On: Jan 11th, 2014

Answered by: Sumithav29 on: Jun 26th, 2014

In the File propertes, we have an option Number of intial rows to skip

Answered by: Rajesh on: Jan 31st, 2014

From Import Flat File Wizard, Edit the setting - Start Import At Row value as 3, that would skip/remove the first and second record and start importing from the third record.

How to only last 100 records from a flatfile?

Asked By: Interview Candidate | Asked On: May 26th, 2012

Thru Informatica how we can load only last 100 records.

Answered by: kalpeshradadia on: Jun 23rd, 2014

SQ---- Exp ---- Sorter----Exp --- Filter---Sorter --- Target. Connect the source qualifier transformation to an expression transformation. In the expression transformation, create the below ports: ...

Answered by: Ankit on: Feb 15th, 2014


Transaction control transformation to get flat file names

Asked By: sureshbabu | Asked On: Jun 16th, 2013

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...

Answered by: Mayur on: 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

Answered by: Goutham on: Oct 11th, 2013

In source analyser,open ur source flat file and there will be an property called "ADD CURRENTLY PROCESSED FILE NAME" jst enable it and make the SourceType = Indirect in session properties.

Hope this will help


What is the maplet?

Asked By: Interview Candidate | Asked On: Sep 21st, 2004

Maplet is a set of transformations that you build in the maplet designer and u can use in multiple mapings.

Answered by: sandeepbabu on: Apr 21st, 2014

Maplet is a resuable object,created with business rule using set of transformations and maplet is created with i/p maplet transformation and o/p tarnsformation. Maplet can be created without i/p maplet transformation.

It can be divided into two type:

1)active maplet
2)Passive maplet

Answered by: abhishek_upadhyay on: Sep 18th, 2008

Basically mapplet is a subset of the mapping in which we can have the information of the each dimension keys by keeping the different mappings created individually. If we want a series of dimension keys in the final fact table we will use mapping designer.

Which objects cannot be used in a mapplet transformation

Asked By: sivaramkumar | Asked On: Mar 7th, 2007

Answered by: venkat on: Apr 11th, 2014

We can not use folloeing transformations in a mapplet. Target: This will change the difference between mapping and mapplet. XML and COBOL sources. Normalizer: Im not sure if we can use it as a trans...

Answered by: prafulla kumar nayak on: Mar 18th, 2014

Below objects we can use inside maplet

1.Non reusable sequence generator transformation.
2.pre or post stored procedure transformation.
3.Normalized transformation
4.xml source qualifier transformation
5.xml source

What is the status code?

Asked By: Interview Candidate | Asked On: Sep 21st, 2004

Status code provides error handling for the Informatica server during the session.The stored procedure issues a status code that notifies whether or not stored procedure completed sucessfully.This value can not seen by the user.It only used by the Informatica server to determine whether to continue running...

Answered by: venkat2ram on: Apr 11th, 2014

Status code is used to determine the status of the execution of the code. i.e. if you used command task, Informatica will post the command to OS and when it is completed the OS will return a status c...

What r the rank caches?

Asked By: Interview Candidate | Asked On: Sep 21st, 2004

During the session ,the Informatica server compares an inout row with rows in the datacache.If the input row out-ranks a stored row,the Informatica server replaces the stored row with the input row.The Informatica server stores group information in an index cache and row data in a data cache.

Answered by: venkat2ram on: Apr 11th, 2014

Rank caches are the caches created to calculate the rank while session run for Rank transformation. Index cache and Data cache Index cache stores the values of the key column i.e. rank port here. D...

What is the way to add the total number of records that have been read from src in the tgt file as last line?

Asked By: N SRIRAM K | Asked On: Jun 25th, 2007

What is the way to add the total number of records that have been read from src in the tgt file as last line? Let me clear you if my tgt is a flat file and want to add total number of records that are written in tgt as a last line with sysdate.

Answered by: Surbhit on: Apr 1st, 2014

Use an aggregator and do no group by any key

Answered by: Ankit Kansal on: Feb 15th, 2014

Easy way of achieving the functionality is with Unix commands however if you want to achieve it using Informatica only then Then just before dumping your data to your target use aggregator count() f...

Joiner transformation master detail

Asked By: sarun5 | Asked On: Feb 18th, 2008

Suppose you have 2000 records in one table and 12000 in another which one you will consider as master and detail?

Star Read Best Answer

Editorial / Best Answer

Answered by: ghola

View all answers by ghola

Member Since Jul-2008 | Answered On : Aug 15th, 2008

The joiner transformation compares each row of the master source against the detail source. Hence, fewer number of rows in master means fewer iterations of join comparison.

Secondly It is easier to cache the table with fewer number of rows.

Hence, using the table having the fewer number of rows as a master improves the performance.

Answered by: ponnana on: Mar 11th, 2014

What if there are 200 records in both tables but one table is having 20 columns and other table has 40 columns is present. In this scenario which table has to be chosen as master n detail. Please clarify.

Answered by: ram_infa on: Sep 13th, 2011

The table with 2000 will be considered as a mater table and table with 12000 considered as detail table caz the joiner transformation compares master data against detail so less no of iterations means less joins thus it enhances the speed or performance

First | Prev | | Next | Last Page





twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.