Series: Subject: Topic:

Informatica Interview Questions

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

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

How to send email from Informatica with post-session success/failure

Asked By: Tejasree | Asked On: Jun 30th, 2006

Hi all,i need to put the value of a col (request-id) in the text of the body of the post-session success/failure email which I have to send in Informatica. How to achieve this? We cannot, I guess, use a parameter file for this as it would take the same value every time and put it in the email. I want...

Answered by: kalyani.y on: Oct 9th, 2012

Create the EMAIL Task, in Properties Tab 1. EMAIL USER NAME : give the email id required 2. Subject as %w -- %e 3. Email Text as %g Session Start time : %b Session completion Time : %c Total Re...

Answered by: rajeshmunikuntla on: Jun 6th, 2011

Pls Help me,how to send email from informaticas Log file is the Requirement, i need log file as Email IN Box

What r the join types in joiner transformation?

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

Normal (default) master outer detail outer full outer

Answered by: audi on: Oct 8th, 2012

There are 4 Types of Joiner Trasnformations: 1) Normal 2) Master Outer 3) Detail Outer 4) Full Outer Note: A normal or master outer join performs faster than a full outer or detail o...

Answered by: sithusithu on: Jan 19th, 2006

follw thisIn the Mapping Designer, choose Transformation-Create. Select the Joiner transformation. Enter a name, click OK. The naming convention for Joiner transformations is JNR_TransformationName. E...

Typical scenario - schedule

Asked By: n.sriramk | Asked On: Nov 7th, 2010

Please help to set up following scenarioi have a source EIther file or db tableeno ename sal dept101 sri 100 1102 seeta 200 2103 lax 300 3104 ravam 76 1105 soorp 120 2want to run a session 3 times.First time: it should populate dept 1second time: dept 2 onlythird time: dept 3 onlyhow can we do...

Answered by: MAHESH MANAM on: Sep 27th, 2012

We can solve this issue by the following types: First, we can create a mapping parameter and run the mapping in each time give the parameter value according to your requirement. Second, we can creat...

Answered by: dileep671 on: Jul 25th, 2012

Put this query in Source Qualifier select empno, ename, sal, deptno from emp_src where deptno not in (select deptno from emp_trg); Then connect it to Rank Transformation In the properties, Select To...

Update target table

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

Can we update target table without using update strategy transformation?

Answered by: MAHESH MANAM on: Aug 22nd, 2012

Yes, By using session level properties. In that use follow the steps Session --> Edit --> Properties --> Treat source rows as --> Update and also you should check options in Mapping --> Target --> U...

Answered by: pranyarockvi on: Jul 29th, 2012

Yes we can , it is the just that update strategy is used for conditional updates, and the update option available at the mapping level in the target is update without any condition.

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.