Series: Subject: Topic:

Informatica Interview Questions

Showing Questions 61 - 80 of 1135 Questions
First | Prev | | Next | Last Page
Sort by: 

How to delete duplicate rows in flat files source is any option in Informatica

Asked By: sravan | Asked On: Jan 25th, 2006

Answered by: Chinna on: May 20th, 2013

Using Sorter Transformation it will delete duplicate records and using Expression Transformation... "c S->SQ->EXP->Router->TR.... Exp Logic=V_Prod_id=Prod_id V_Dup_...

Answered by: Madhuri on: Jun 22nd, 2012

Use sorter transformation after SQ and check the distinct check box of sorter.finally connect to the tgt.

If you want to create indexes after the load process which transformation you choose?A) filter tranformationb) aggregator tranformationc) stored procedure tranformationd) expression tranformation

Asked By: rrvathana | Asked On: Apr 13th, 2006

Answered by: SAMREEN on: May 17th, 2013

Stored Procedure

Answered by: Prasad on: Jul 14th, 2006

Hi,Its usually not done in the mapping(transformation) level. Its done in session level. Create a command task which will execute a shell script (if Unix) or any other scripts which contains the creat...

Informatica transformation

Asked By: KanikaC | Asked On: Apr 29th, 2013

What is the diffference between SQL override and SQL transformation ?

Answered by: Bilal on: May 7th, 2013

There is no different between them. The only thing is, SQL override is executed at the beginning of a mapping and the SQL-Transformation is executed downstream of the mapping

Repository services not started

Asked By: Devender Sharma | Asked On: May 2nd, 2013

I have Oracle 9i and windows XP installed on my machine and try to install Informatica 8.6 and after successfully installing client and server try to do all setting in power center administration console and create new repository but repository services are not up and giving error that unable to connect...

Informatica primary server process

Asked By: sahana | Asked On: Nov 28th, 2007

Which is primary server process in Informatica?1.Repository manager 2.Load manager 3.Workflow manager 4.Workflow designer

Answered by: alex on: Apr 29th, 2013

Load manager

Answered by: suvashis on: Dec 12th, 2007

Hi.."load manager' is the primary process of informatica power center server"DTM-data transformation manager" is the secondary prcess..go through the architecture  of informatica power center server..thank u...suvashis

How to join two tables without common columns?

Asked By: dwhin4matica | Asked On: Feb 27th, 2013

Answered by: Vikas Nandal on: Apr 21st, 2013

Create a Dummy Port in both tables and assign same value e.g. 1 to both ports in expression transformation before joiner.
Now in join condition use this dummy port to join both tables.

Answered by: anshuman trivedi on: Mar 3rd, 2013

You join these table using null key.

Pass {} to the key,I am sure it will work.


How to partition the session?(interview question of cts)

Asked By: vijitha | Asked On: Jan 22nd, 2007

Answered by: dl_mstr on: Feb 10th, 2008

By default when we create the session, workflow creates pass-through partition points at Source Qualifier transformations and target instances.  Partition points mark the thread boundaries in...

Answered by: sreedhark26 on: Mar 12th, 2007

When you create or edit a session, you can change the partitioning information for each pipeline in a mapping. If the mapping contains multiple pipelines, you can specify multiple partitions in some p...

Hw to work with pmcmd on windows platform

Asked By: Ramesh | Asked On: Nov 8th, 2006

Answered by: Joe on: Feb 7th, 2013

ECHO OFF This automates the informatica workflow run using pmcmd ECHO c:informaticaserverinpmcmd startworkflow -u username -p password -s server:host -f Folder -wait MYWORKFLOW

Answered by: dl_mstr on: Feb 10th, 2008

C:-->Program Files-->Informatica PowerCenter 7.1.3-->Server-->bin-->pmcmd.exe

Etl developer daily routine and reporting hierarchy

Asked By: mty49159 | Asked On: Feb 7th, 2013

Can anybody plz explain what would be the daily routine and reporting hierarchy of an etl developer in sales project...

Where and how you use UNIX shell script in Informatica

Asked By: jackie | Asked On: Apr 16th, 2007

Can any one explain where we use UNIX shell scripts in Informatica? Provided with example if possible.Thanks.......Jc

Answered by: nitin_2002786 on: Jan 24th, 2013

Script can be used for several task
1) To run the worklfow, u can create script
2) To schedule the task/wkf u can schedule the script in cron tab
3) To Export/Import object
4) To automate the dep group
5) To bounce the service
U name it, and it can be done using script !!!1

Answered by: priyank_divya on: Jul 9th, 2012


We can invoke Unix Scripts through

--> Command task
--> Under Session, Pre/Post session commands

What is the use of ODBC.Ini file while installing server?

Asked By: SRIRAM N | Asked On: May 9th, 2007

Answered by: nitin_2002786 on: Jan 24th, 2013

ODBC.ini file has the entry of drivers required for the third party software like sybase, Teradata etc. Its located at server/bin loc.

Answered by: priyank_divya on: Jul 9th, 2012

Odbc.ini file is used to define the connections(DSN names,tcp/ip port) for database through which Informatica connects to the database.

How to create connection for source flat file? Which session properties need to be changed?

Asked By: Shely | Asked On: Sep 27th, 2007

I have to load data from db2 flat file to ms SQL server target tables.

Answered by: nitin_2002786 on: Jan 24th, 2013

First for Flat file a connection is not required.
All we need to provide is the path of the path in the mapping properties.

Answered by: Anil Borru on: May 28th, 2012

It will save in Informatica Server below path:


How do we kill process if the process is running?

Asked By: sjigars | Asked On: Oct 13th, 2007

Do we have any specific number which we have to use with kill command?

Answered by: nitin_2002786 on: Jan 24th, 2013

U can use
ps -ef | grep USERID
where USERID is the Id with which the process is running.
It will give you output with two Id and detail of process name
kill PID
Kill -9 PID (if kill does not work )

Answered by: priyank_divya on: Jul 9th, 2012

If its an Unix installation, we can use the below commands:

ps_ef --> To know the processes running in backend.
kill -9 --> to kill a process forcefully.

How to explain sales project in interview.

Asked By: kishore sai | Asked On: Aug 3rd, 2012

How to explain sales project in interview.Could u tell me modules or dim table with some column names and facts how to move data from dim to facts.And give me what logic u implement in that projects

Answered by: Lokesh M on: Jan 3rd, 2013

For explaining your sales project: You can follow these points and cover them based on your actual project. 1. Name of the Project 2. Name of the Client 3. Brief Description of the Client 4. Brief ...

Dimension table vs fact table

Asked By: goutamhere2interact | Asked On: Jun 18th, 2008

What is the main difference in the logic when you create a mapping for a dimension table with that of a fact table in Informatica.

Answered by: Amar on: Nov 30th, 2012

The main logical difference is that we use connected lookup while loading dimensions and unconnected look up while loading facts

Answered by: ASHU on: Jan 21st, 2012

A Dimension table contain descriptive (detailed) data and a fact table contain measurements (facts) which are used to evaluate a business, all numeric are not a facts but the numeric which are key performance indicators is known as facts.. fact table contain summarized data....


Tell me something about your current project?

Asked By: tiya123 | Asked On: Nov 16th, 2012

Can any one please tell me how to explain manufacturing domain Informatica project in interview as a etl developer and from where to start and end.

Answered by: vijay on: Nov 26th, 2012

Start your project description, then move on to your role and responsibilities and then about your team and so on...

Look up function

Asked By: shojol13 | Asked On: Oct 16th, 2012

What is a look up function? What is default transformation for the look up function?

Answered by: pranusha on: Nov 8th, 2012

The lookup function is used to compare source data with another table based on a certain condition. If the condition is true than the lookup function returns columns that satisfy condition.
The default transformation for lookup function is lookup transformation.

What is the optimum method to load five flat files with same structures into target? What is meant by file repository?

Asked By: venki | Asked On: Dec 18th, 2006

Answered by: Naveen on: Nov 8th, 2012

Set source file type as INDIRECT

Answered by: Amit Gaikwad on: 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 ...

How u will create header and footer in target using Informatica?

Asked By: kk | Asked On: Jun 10th, 2006

Answered by: lakshmi on: Nov 7th, 2012

As uma told...she is rite,but may i know how to create footer in a flatfile

Answered by: varun joshi on: Aug 7th, 2006

you can always create a header and a trailer in the target file using an aggregator transformation.Take the number of records as count in the aggregator transformation.create three separate files in a...

If a record is updated multiple times before session is run, how do you track those changes in SCD type 2?

Asked By: Minnu | Asked On: Apr 16th, 2007

Answered by: narendraterainfo on: Oct 14th, 2012

If the ETL is not ussing Full Pushdown optimization or Target Pushdown optimization . We can track with insert Time_stamp

Answered by: priyank_divya on: Jul 9th, 2012

We can track the changes in SCD type 2 in many ways:

--> A time column
--> Mentioning a version

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.