Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

KOTI

• Oct 31st, 2011

First find out the problem whether it is due to aggregator transformation or not. Run debugging...

sivakp

 Profile Answers by sivakp Questions by sivakp

• Mar 13th, 2011

You can use incremental aggrigation.

Answer Question  Select Best Answer

Can we use both SCD Type1 and Type2 transformations in one mapping? If yes how?

Nagaraju Puppala

 Profile Answers by Nagaraju Puppala Questions by Nagaraju Puppala

• Feb 9th, 2011

Yes,,We should use the both logics in a single mapping in the real time.When an organization maintainig the employee data..It should maintain all historical data like the salary, designations etc. and...

Nagaraju Puppala

 Profile Answers by Nagaraju Puppala Questions by Nagaraju Puppala

• Feb 9th, 2011

Yes,You can create SCD1, SCD2 logic in a single mapping :)Considersd Employe Table: which contains the columns eno, ename, sal, designation, phone, address.while you are loading in to the warehouse ta...

Answer Question  Select Best Answer

What is the significance of the file odbc.ini?

sridkaretl

 Profile Answers by sridkaretl Questions by sridkaretl

• Oct 21st, 2011

The main significance of ODBC is it to connect to the desired database and fetch the data.

Sriteja

• Aug 27th, 2011

One of the uses of the ODBC.ini file is to handle SQL Server, Teradata connections from Unix flavoured Informatica Server installations...

There can be more to it.. However, we use odbc.ini in our project to connect SQL Server database from powercenter installed in Linux server..

Answer Question  Select Best Answer

Which functions are used in Union Transformation?

rangarao.dwh

 Profile Answers by rangarao.dwh Questions by rangarao.dwh

• Jan 9th, 2012

Union Transformation works like as Union All in SQl and in this transformation we cant use any external functions like avaliable in expersion editor means which is specially designed for joining the records vertically.

sridkaretl

 Profile Answers by sridkaretl Questions by sridkaretl

• Oct 21st, 2011

i didnt understand the question. First, a union transformation is active transformation which is used to combine data from multiple sources into single target. This union transformation supports union...

Answer Question  Select Best Answer

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file without adding extra columns?

ETLKaps

• Apr 10th, 2012

For the FlatFiles, in source definition, there is a option to include file name as one of the output port. There is no need to add FileName in actual source file. Informatica will append it to every r...

sridkaretl

 Profile Answers by sridkaretl Questions by sridkaretl

• Oct 21st, 2011

First thing i would like to know is whether the different targets are of same database or not. If the target is from same database then you can use router transformation by importing the flat file into source either as de-limited or fixed width.

Answer Question  Select Best Answer

Is it possible that a Star Schema contains more than one fact tables? If Yes, How?

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Jun 21st, 2012

Yes we can logical fact in terms of obiee in star scema
and also with then help of Confirmed dimension we can have another fact in starschema

Rajesh

• Aug 1st, 2011

NO

Answer Question  Select Best Answer

Rambabu

• Jan 17th, 2012

Yes we can do it

Shravani

• Jan 13th, 2012

Yes we can.

Answer Question  Select Best Answer

How to kill 10 workflows at a a time ?

vizaik

 Profile Answers by vizaik Questions by vizaik

• Oct 25th, 2011

Write 10 pmcmd commands with abortworkflow option in one bat/sh file and execute at once

wanilkumar

 Profile Answers by wanilkumar Questions by wanilkumar

• Oct 7th, 2011

It is not possible to kill multiple workflows at a time. You must Abort/Stop one at a time.

I think starting with the version 8.6 you can run the same workflow multiple times at the same time.

Answer Question  Select Best Answer

What is the structure of the reject file in Informatica?

Ramarao

• Jul 10th, 2012

We need to give the option in target level for rejected data (means needs to give the path of the badfiles to capture the rejected data)

Kiran

• Apr 15th, 2012

There is no predefined structure for bad files. It has the same structure as of the target table.

Answer Question  Select Best Answer

Can we update target table without using update strategy transformation?

MAHESH MANAM

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

pranyarockvi

 Profile Answers by pranyarockvi Questions by pranyarockvi

• Jul 30th, 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.

Answer Question  Select Best Answer

Mahendra Rajpoot

 Profile Answers by Mahendra Rajpoot Questions by Mahendra Rajpoot

• Sep 17th, 2014

Staging area may be required if you have any of the following scenarios: Delta Loading: Your data is read incrementally from the source and you need an intermediate storage where incremental set of y...

MAHESH MANAM

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

Answer Question  Select Best Answer

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.

pradyumna sahoo

• Jan 28th, 2015

Shortly u describe your projects like project name ,& which domain u work? basically u tell your project architecture and its flow .

vijay

• Nov 27th, 2012

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

Answer Question  Select Best Answer

Dhiraj Chachane

• Sep 28th, 2017

Hi anybody Can you let me know about how to load flat files to target without mappings?

Sarita

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

Answer Question  Select Best Answer

Which means the first record should come as last record and last record should come as first record and load into the target file?

sandeepsandeep

 Profile Answers by sandeepsandeep Questions by sandeepsandeep

• Aug 11th, 2014

In the Sequence generator, write the query and then order by DESC. this will do a reverse of all records first will go last and last will go first.

venkat2ram

 Profile Answers by venkat2ram Questions by venkat2ram

• Jul 14th, 2014

This is pretty simple.

Use sequence generator to number the records.

Then sort them in descending order using sorter transformation.

Answer Question  Select Best Answer

Gayathri

• Jul 21st, 2014

Go to Session Properties->Config.Object, Make Stop on Error as 0.
This will not fail the session if there is error in 1 record. This will load all error free records.

Dinesh

• Jul 21st, 2014

If the source is FF, then use skip first 299 rows and then start loading.

If the source is relational then u row number.

Answer Question  Select Best Answer

How to tune the session,workflow for better perfomance,what are the things we consider for better performace?

Ruhi

• Feb 1st, 2016

Partitioning, line sequential buffer length, tracing level as terse, collect performance data as enabled, commit interval are some of the pointers for session level performance tuning.

Rajesh Kumar

• Sep 16th, 2014

Make sure the Sorted Inputs enabled for Joiner, Lookup and Aggregate transformations in workflow.
Use Dynamic cache for lookups whenever needed otherwise cache takes more spaces (instead of cache)

Answer Question  Select Best Answer

Hi All,

I am faced with a scenario wherein while data flow from source to target, a condition would be checked that if the data is present in target then a source column will be updated as U and if the data is not present in target then the source column will be updated as I

Vipin

• Nov 11th, 2014

Lookup the target table based on key and check either record is exist or not. If Lookup returns any record then By using update Strategy update or insert. Note : to update record using Update Strategy you need to apply Primary key at INFA Laval at least otherwise it wont work.

KJ

• Nov 10th, 2014

Its never the source but the target column that gets updated with U or I to identify the updated or newly inserted rows.

Answer Question  Select Best Answer

What is meant by informatica grid? what are the component of informatica grid?

Fabio Mendon?a

• Mar 31st, 2016

When I use a grid in a Workflow and my second session (S2) has distributed on 3 links .... Question: The process that run on link 1 (S1 , S2 , S3 , S4, S5) , get the same link until the end (S5) ?...

Pruthvi S

• Dec 21st, 2014

A grid is an alias assigned to a group of nodes that allows you to automate the distribution of workflows and sessions across nodes. When you use a grid, the Integration Service distributes workflow...

Answer Question  Select Best Answer

Source
id,name
1,a
2,d
3,c

Target
detail
((1/a)(2/b)(3/c))

Manas

• Feb 4th, 2015

We can use expression transformation here in which we can define variables that store the string in the below mentioned way: var1=var1||(||id||/||name||) output_port=(||var1||) After this w...

XYZ

• Feb 4th, 2015

Using a Union Transformation

Answer Question  Select Best Answer

I am new to Informatica and learning it, Can anybody please tell me how we receive source as flat file in informatica? From where we get this flat file?

yusuf

• Feb 20th, 2016

You create a one note in desktop and insert the data with delimiter as you require and save it . Go to source qualifier and import as flat file and import from desktop.

xyz

• Feb 19th, 2016

We need to create the Flat file or import the file if already exists. Source Analyser--> Create or Import file

Answer Question  Select Best Answer