Series: Subject: Topic:

Informatica Interview Questions

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

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

In SCD type2

Asked By: kalyanraghava | Asked On: Sep 12th, 2012

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?

Answered by: Anupama on: Oct 8th, 2012

We can use SCD without using lookup.

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

As of my knowledge we can do SCD Type 2 by using joner transformation. First take the source and target(i.e which is target) as source and join these two by using surrogate key like master outer join(...

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.

How to read the data from XML and flat files in Informatica?

Asked By: sunitha ravula | Asked On: Apr 25th, 2011

Answered by: MAHESH MANAM on: Aug 16th, 2012

From flat file you use the following wys: --> In source analyzer you can create file by manually -->you can import file -->you can use any of the flat file and give session properties in that correc...

Answered by: dileep671 on: Aug 3rd, 2012

Go to Source analyzer , then import XML Source, a wizard opens up.. select the Schema Definition (XSD) of th XML file

When you run the session, give the XML file name and XML file directory path.

What is staging are why we need it

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

Answered by: MAHESH MANAM on: Aug 16th, 2012

It is a automated process of building a data warehouse which involves taking the data from disparate source systems, converting them into a consistent form that can be loaded into the warehouse and pe...

Find out duplicate records using aggregator

Asked By: buvanalogu | Asked On: Dec 13th, 2007

How to find out duplicate records using aggregator. Pls explain with example. What is the need for placing joiner after aggregator. I just tried like the following:count the records and group by all the columns. If the count=1 then it will be a valid record. What to do if the count >2.Means file contains...

Answered by: priyank_divya on: Aug 7th, 2012

Hi, Its similar to the SQL query, SELECT * FROM ,,.... FROM TABLE_NAME GROUP BY ,,..... HAVING COUNT(*)=1 Similarly in Informatica Aggregator transformation, select group by for all the columns and...

Answered by: arun.menon on: Oct 24th, 2008

With respect to your query. Try getting the session log details regarding the session run. In case if you are not able to get sufficient informations, running the workflow in Verbose data mode. That will give you an exact account where things went wrong.CheersArun


Asked By: mahesh | Asked On: Nov 6th, 2011

I have 2 sources one is relational table with 7 ports second is flat file with 8 ports.How can I get the combined output and I should not do any modifications to the source structure?

Answered by: priyank_divya on: Aug 3rd, 2012

Hi, I think we can obtain the results by using Joiner transformation. If the sources have no common columns, we can add one extra column with a value 1 in both the sources and then can join based on ...

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.