# Informatica Interview Questions

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

#### How to generate a star pattern using Informatica?

How to generate a star pattern using Informatica depending on the number of rows in the input file

Suppose there are 7 rows in the source file (any type of data), the target should have 7 rows of stars in the following pattern:-

*
***
*****
*******
*********
***********
*************

#### SUM

• Oct 8th, 2015

V_star=iif( v_vount < = 1,*,rpad(v_star,vcount,*))
v_count=v_count+2
O_STAR=V_STAR

•

#### sudeep

• Sep 18th, 2015

In general Fact table is normalized and Dimension table is denormalized. So that you will get all required information about the fact by joining the dimension in STAR schema. In some cases where dimensions are bulky then we we snowflake it and make it normailzed.

#### Niranjan

• Apr 22nd, 2015

Normalization is splitting 1 table to multiple tables to avoid insert/update and delete anomalies. They are done in OLTP systems. De-normalization is exact opposite of normalization, here multiple tab...

•

#### Load 10000 Records into Dynamically Created 100 Files

How to load 10000 records into dynamically created 100 files and to load 100 records in each?

#### Snehasis

• Sep 11th, 2015

This can be done using TC transformation. In an expression before the TC, keep a counter which increments for each row passed. When the counter reaches 100, reset the counter to 0. In the expression...

•

#### How to join the data of two tables which does not have common columns

how to join the data of two tables which do not have common columni mean how to perform non equi join in informaticaEg:just like getting data from emp and salgrade table of oracle where sal is between losal and hisalthanksvenu

#### milind

• Aug 6th, 2015

Yes dummy column will work
other way is to use mapping variable :)

#### ashish

• Sep 27th, 2014

You can create a dummy port in each source and assign 1 to both port and drag the both sources in joiner tr and give join condition on dummy port, After that you can use filter condition on your location

•

#### Extracting data from SAP R/S using Informatica

( cross platform integration) - I am new to informatica n SAP , i got assignment work on integration of informatica and SAP R/3 , i need to import data from SAP , i went to could of videos on YouTube provided by Informatica Support , they are saying you need to install RFC libraries that are available on SAP market place, RFC libraries are platform specific , i do have SAP system on Unix and informatica...

#### prashanth naik

• Jul 6th, 2015

You can do it by configuring the Application connection, the connection will generate the ABAP code which hits SAP R/3 system and does data extraction.

•

#### Implementing SCD Type2

In SCD Type2 scenario, Informatica has no control on the DML operation.
How will we make sure that updates happen before Inserts in SCD Type2 dimension so that we can avoid the AK constraint error.

#### Abhilash tyagi

• Jun 6th, 2015

You can try to change the name of the target instances. For example, let us consider we have 2 instances of targets CUST_D (insert) and CUST_D1 (update), try to change the name of insert instance to C...

•

#### Dimensional modelling vs Data modelling vs ER modelling

What is Dimensional modelling ? What is the difference between Data modelling and Dimensional modelling and Erwin modelling.

#### Manjunath

• Apr 9th, 2015

both Dim Modeling and ER modeling can be 3NF, which is highly normalized, As raj mentioned ER is used for OLTP and DM for OLAP. in both the cases data is stored in a set of tables and related to each ...

#### Sharat

• Jan 5th, 2015

Raj, 1NF is highly denormalized and the higher forms are more normalized. You said Dimensional Modeling is for datawarehouses and uses 3NF. Contains denormalized data. 3NF is highly normalized and how can the datawarehouses can have denormalized data

•

#### Rows pivoting

Source:
col2 col1
a 1
b 1
c 1
d 1
p 2
q 2
r 2
x 3

how to do this...
thanks
krishna

#### Manjunath

• Apr 9th, 2015

Converting rows into columns is de-normalizing, you may have to use aggregate transformation to do so. Note: vice verse is normalizing the data, that can be done using normalizer transformation. U...

#### Shiva

• Jan 14th, 2015

Pivoting means converting rows to column and vise verse.

Please use normalization transformation to achieve this.

•

#### What are variable ports and list two situations when they can be used?

• Mar 21st, 2015

Informatica follow input variable n output process.thus you can make some calculations in variable port n copy them to the output port to achieve some purpose mostly used in expression tf

#### Kameshwara

• Aug 8th, 2013

variable ports are used in transformations like Expression/Aggregator where you can hold a value of incoming data. This can be helpful when you want to check if incoming column value is same or a cha...

•

#### Informatica ERROR REP_12014 : Error occured while accessing the Registry

HiIam learning informatica 8.1 ( which is what i could get my hands on)..I am connecting to oracle 10g.I created 2 connections to the DB using Connection --> Relational Connection Browser.The Source and Target are the same db in this case, just diff table names. But created 2 separate connections .I 1st created the TUTORIAL_SOURCE and then copied it to TUTORIAL_TARGET and gave it a new name. then...

#### Gatla Dileep reddy

• Feb 16th, 2015

It is a DB issue, If the Session failed in middle just try to recover the workflow.

#### Vids

• Aug 13th, 2013

The error seems to be DB error . First of all , check at the database level if the source and the target table are created correctly. Then using INSERT stmt , try to insert a record in Oracle databa...

•

#### How to perform below scenarios

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 3rd, 2015

Using a Union Transformation

•

#### Anjali

• Jan 31st, 2015

Suppose we have two dim Dim_Location and Dim_Customer then how in fact table we can map values of Loc which are corresponding to a customer , if loc has val 1 for Chennai and 2 for Bangalore then how we can show the corresponding loc values for cust ?

• Jul 18th, 2006

hi,usually source records are looked up with the records in the dimension table.DIM tables are called lookup or reference table. all the possible values are stored in DIM table. e.g product, all the e...

•

#### Tell me something about your Current Project?

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.

• Jan 27th, 2015

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

#### vijay

• Nov 26th, 2012

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

•

#### Transaction control transformation to get flat file names

Hi Folks,

I have scenario like, I have ten flat files to be loaded in to target but I need to load file names in to a table in mapping level. I think we can do achieve though TC transformation. Unfortunately I did not get though.. Please advise how to implement the logic. ( I need to capture in mapping level only).

This question has been asked one of the interviews.

#### BRAHMAIAH

• Dec 30th, 2014

Hi folks, If all files have structure then we go for Indirect file method.we set this property at session level by selecting the source def. After define of the source def at mapping level just do...

#### Mayur

• Jun 23rd, 2014

Got to flat file properties and there you will find one icon Add FileName column to this table just click on that option and you can able to add currently processing file. Thank you

•

#### BRAHMAIAH

• Dec 30th, 2014

There are 3 ways are available to generate sequence numbers with out using Sequence Generator Transformation, 1) Using Exp Tfn variable concept v_cnt(v)=o_cnt+1 o_cnt(o)=v_cnt 2)using mapping variabl...

#### Venkateswara Rao Rajanala

• Oct 14th, 2014

You can use output port and say CUME(1).. this will automatically generate the sequence or use Variable port
Var= var+1 and Output port = Var...This will generate the sequence for you

•

#### Update Strategy

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.

•

#### How to remove the null values in flat file ?

Import flat file from the source (with nulls) it should display without null values in the target

#### laxmi

• Nov 10th, 2014

We can use validate record component with is_null() function.

#### sandeepsandeep

• Aug 11th, 2014

After importing the flatfile, after the source qualifier use an expresssion transformation. In expression transformation use the condition IIF(column=NULL,0,Column)

(you can use either 0 or any other value u like..)

•

#### Kiran Ghatage

• Nov 7th, 2014

You will find following tool from informatica marketplace useful for this requriement. https://community.informatica.com/solutions/xml_reporter_for_informatica

#### kumar

• Sep 28th, 2006

yes, we can generate reports using Metadata Reporter... It is a web based application used only for creating metadata reports in informatica.Using metadata reporter we can connect to repository and ge...

•

#### Performance of an Aggreartor

Under what conditions selecting sorted input in aggregator will still not boost session performance ?

#### Venkateswara Rao

• Oct 14th, 2014

If all the rows belong to the same data group . Then it doesn't improve anything

#### Knonw

• Sep 16th, 2014

If in session property Incremental agg. is enabled. 2. in case of Nested aggregation 3. if treat row as data driven is selected in session property. In all of above cases aggrigator performance wil not be boosted up though its using sorted i/p.

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

#### Have Interview Question?

Please select the most appropriate category and mention a brief question title along with clear question details.

Name:
Email:
Category :
Sub Category :
Question Title:
Question in Detail :
Job Role (Optional) :
Company (Optional) :

### Optional Features

#### Subscribe to GeekInterview Newsletter

Yes, Subscribe me to Interview & Career Tips