Series: Subject: Topic:

Informatica Interview Questions

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

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

Multiple flat files loading

Asked By: win_bhatia | Asked On: Dec 27th, 2009

If there are multiple source flat files with different names but same file structure. How do we load all those files to the target in one step?

Star Read Best Answer

Editorial / Best Answer

Answered by: etluser

View all answers by etluser

Member Since Dec-2009 | Answered On : Dec 31st, 2009

Follow the below steps-
1. Create the mapping as if there is only single source and target.
2. Now create an additional file on the server which will list the multiple source file names along with their paths.
3. Specify the path and name of this file in the "Source File" under session properties. 
4. Now the most important thing - Set "Source Filetype" as "indirect" under session properties.

Answered by: priyank_divya on: Aug 3rd, 2012

There is a concept of Indirect filelist for processing multiple files with similar structure.

Answered by: Rajath on: Feb 20th, 2012

What if there are n source files(number may vary) with the same structure? File name maybe similar for e.g. TxtFile_1,TxtFile_2,TxtFile_3...........TxtFile_n

Can we update target table without using update strategy transformation? Why?

Asked By: phanimv | Asked On: Apr 20th, 2007

Answered by: Amit Gaikwad on: Jul 26th, 2012

Step 1: Go to session , and in treat source rows as :UPDATE
step2: in target table option select INSERT and UPDATE ELSE INSERT :)
Step 3:Refresh and Run the session .

Answered by: nagadurgaraju on: Sep 1st, 2010

By using source qualifier transformation to update tha target table,through SQL overriding...

In which condtions we can not use joiner transformation(limitaions of joiner transformation)?

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

Both pipelines begin with the same original data source. Both input pipelines originate from the same source qualifier transformation. Both input pipelines originate from the same normalizer transformation. Both input pipelines originate from the same joiner transformation. EIther input pipelines contains...

Answered by: Twinkle on: Jul 25th, 2012

Why Joiner transformation cannot be used when either of the input pipeline contains an Update Strategy transformation.

Answered by: divakar on: Nov 5th, 2007

We cannot use joiner transformation in the following two conditions:-1. When our data comes through Update Strategy transformation, or in other words after Update strategy we cannot add joiner transfo...

Hi... This was asked in acccenture interview can anyone plz tell me the answerwhat is the difference between Informatica 7.1 and 8.1

Asked By: Interview Candidate | Asked On: Jan 9th, 2007

Answered by: jyothi on: Jul 24th, 2012

service oriented Architecture,Pushdown Optimization,sql t/r is added,java t/r is add

Answered by: prashant on: Sep 3rd, 2011

Main difference between informatica 7.x and 8.x are:-

1. Java transformation is introduced in Informatica 8.x. while was not in 7.x

2.and Power exchange tool also introduced in informatica 8.x while was not in 7.x

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.