Series: Subject: Topic:

Informatica Interview Questions

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

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

Can we revert back reusable transformation to normal transformation?

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

Answered by: anilkumar vadlamudi on: Mar 13th, 2014

we cant change the reusable transformation to non reusable transformation y bcoz once u check the reusable this will take reusable otherwise we cant change

Answered by: ram_infa on: Sep 12th, 2011

No! we can't revert back a reusable transformation to a normal transformation.. we can change a normal transformation into reusable but not a reusable to normal.

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

Rows pivoting

Asked By: krishnaadapa | Asked On: Sep 4th, 2013

Source: col2 col1 a 1 b 1 c 1 d 1 p 2 q 2 r 2 x 3 how to do this... thanks krishna

Answered by: snehal on: Mar 5th, 2014

pivoting means aggregating...

u can do a group by on col1

Difference between stop & abort

Asked By: shojol13 | Asked On: Jul 26th, 2012

What is the difference between stop and abort options in workflow monitor?

Answered by: Satish on: Mar 4th, 2014

STOP ensures current session activity / threads on Informatica server are complete and ends the workflow.
ABORT kills current session activity / threads on Informatica server irrespective of its state and ends the workflow.

Answered by: Sudha Rani on: Nov 6th, 2012

If we have to do stop it will stop that step only.again we have to start the workflow then that time it will start which step u have to stop that step only it start run the workflow then abort says we...

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: Ankit on: Feb 15th, 2014


Answered by: Sarita on: Sep 3rd, 2013

Use flat file->src qualifier->rank-> target. In rank select top 100 and do rank index on NEXTVAL

seq gen

I tested it too but not getting an option to insert mapping image here.

Sorter transformation

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

If I enable select distince property in sorter transformation, on what basis the sorter tranformation removes the duplicate data

Answered by: RaghuMVR on: Feb 4th, 2014

It will check all the column values of the records to identify the duplicates.

Answered by: Karthik on: Jan 13th, 2014

The IS removes duplicates only if it is a row duplicate(entire row should be duplicate)

How to remove 2 starting rows from my source flat flie

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

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 do we estimate the depth of the session scheduling queue? Where do we set the number of maximum concurrent sessions that Informatica can run at a given time?

Asked By: renukhareddy | Asked On: Nov 30th, 2005

Answered by: Jose on: Jan 27th, 2014

By default the maximum concurrent session is 10 and during installation we are setting the number of concurrent session.

Answered by: prasadns26 on: Jul 18th, 2006


please be more specific on the first half of the question.

u set the max no of concurrent sessions in the info default its 10. u can set to any no.

Validate no of rows in source and footer

Asked By: sureshgut | Asked On: Feb 15th, 2013

How do you validate the no of rows received in source with footer(count) and if both count matches then only it should load to target?

Answered by: vijay on: Jan 6th, 2014

Design a mapping with 2 flow.1 to load the data into target with all necessary columns.2nd target will have only count information and set a target load plan as said above.In the session level. Set th...

Answered by: saurav on: Apr 3rd, 2013

You can utilize the MD5 hash functionality within the mapping

What is the difference between SQL overriding in source qualifier and lookup transformation?

Asked By: Naveed | Asked On: Apr 2nd, 2007

Answered by: sarada on: Nov 28th, 2013

using source qualifier u can extract the data from sources,in over ride u can write the queries to run in the data base,where as in sql t/f u can write and run the queries in database and get the res...

Answered by: Hemanth Kumar M.N on: Dec 15th, 2007

If you write a query in source qualifier(to override using sql editor) and press validate you can recognise whether the querry written is right or wrong.But in lookup override if the querry is wrong a...

What are the daily routines of an Informatica developer?

Asked By: Swapna Ray | Asked On: Sep 25th, 2013

Answered by: Sarita on: Oct 23rd, 2013

The daily routines of the developer in support role: 1)Do lights on activity,i.e. check if the informatica services are running,any session failed or not,if a file failed then how many records loaded ...

What kind of errors you face daily as an etl developer (Informatica)?

Asked By: Swapna Ray | Asked On: Sep 25th, 2013

Answered by: Sarita on: Oct 23rd, 2013

The errors faced are:

1)Duplicate data in target tables
2)Performance issues
3)File rejections due to error in header and trailer records
4)Logical errors

Scenario based

Asked By: sohamasmi | Asked On: Oct 12th, 2010

If I have a source as below:employeed, familyid, contribution1,a,100002,a,200003,a,100004,b,205,b,20________________________________and my desired target is as below:employeeid,contribution(in percent)1,25%2,50%3,25%4,50%5,50% ____________________________________________________________________________explanation:...

Answered by: saimurali on: Oct 18th, 2013


Source -> aggregator(sorted input option)-> expression t/r-> target

in aggregator t/r calculate the total sum of family contribution and connect all port to expression t/r, in this t/r contribution/toal family_contribution *100 and connect to target, u will get above required output

Answered by: sachin on: Dec 17th, 2012

you need a one source qualifier pipeline to aggregator then ==> a joiner to join aggregator and source qualifier ==> then expression to calculate percentage==> push it to target

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


Answered by: Sanjay Gupta on: Sep 25th, 2013

Please follow following steps: 1. Import one flat file definition and make the mapping as per need. 2. Now make a notepad file that contains the location and name of each 10 flat files. Sample: D:...

Oracle sequence generator

Asked By: krishnaadapa | Asked On: Sep 13th, 2013

How to write stored procedure,which take the sequence name as input and dynamically generates a nextval from that sequence

What is repository size, what is its min and max size?

Asked By: venki | Asked On: Jul 13th, 2007

Answered by: Venkat on: Sep 10th, 2013

Above answer is not correct.

Correct answer is 150 MB

Answered by: chandrarekha on: Sep 28th, 2007


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.