Series: Subject: Topic:

Informatica Interview Questions

Showing Questions 1 - 20 of 1135 Questions
First | Prev | | Next | Last Page
Sort by: 

Load only the first and last record

Asked By: thallojur | Asked On: Nov 12th, 2008

How to load only the first and last record of a flat file into the target?

Answered by: krish on: Oct 16th, 2014

Java transformation in Informatica PowerCenter uses Java programming language to transform the data. It is not necessary to write the entire Java code or use an external Java development environment a...

Answered by: gajaa on: Oct 15th, 2014

Use two pipelines in one find top(seq) using rank in another pipeline least sequence using rank t/r union both send to target

Could any one please help in finding the solution for this workflow related question.

Asked By: Thiyagarajan | Asked On: Nov 7th, 2006

Suppose I have one source which is linked into 3 targets.When the workflow runs for the first time only the first target should be populated and the rest two(second and last) should not be populated.When the workflow runs for the second time only the second target should be populated and the rest two(first...

Answered by: gaja on: Oct 14th, 2014

No , target load plan work for single session only .
it determine the order of targets to load in single session only

Answered by: Venkateswara Rao on: Oct 8th, 2014

Have a workflow variable defined and assign the variable as Var = IIF(Var=3,0,Var+1) .. Have a mapping variable also defined and use the pre session assignment to assign the workflow variable to mappi...

How to write a filter condition to get all the records of employees hired between any two given dates.

Asked By: priya | Asked On: Aug 30th, 2006

Answered by: naveenkumar on: Oct 14th, 2014

Execute the target table for mapping to table

Answered by: ms kumar on: Sep 8th, 2014

Plz generate and execute the target table for every mapping by dropping the the table

How to generate the sequence of keys or numbers in target without using the sequence generator transformation.

Asked By: Thejaswini | Asked On: Oct 4th, 2007

Answered by: Venkateswara Rao Rajanala on: 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

Answered by: ashish on: Sep 27th, 2014

Use the expression transformation. in there create a variable port say count in that write count+1 then assign this port to out put port it will create a sequence .

Performance of an aggreartor

Asked By: BRAHMAIAH | Asked On: Aug 9th, 2014

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

Answered by: Venkateswara Rao on: Oct 14th, 2014

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

Answered by: Knonw on: 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.

Maintaining data integrity

Asked By: abhiastra | Asked On: Sep 11th, 2014

How can I maintain unique surrogate key if 2 separate workflow in different repository run at the same time and insert/update the main table. please let me know how can I achieve the above scenario.

Answered by: Venkateswara Rao on: Oct 14th, 2014

In this scenario the best approach is to define a sequence in Database (ex :oracle ).. Call in informatica when ever you want . even if it is across multiple repositories it will work.

Answered by: Mahendra Rajpoot on: Sep 17th, 2014

Yes, we can. But we need to export/import the mapplet in different repositories. Working with Mapplets: After you create a mapplet, you can validate or edit the mapplet in the Mapplet Designer. You c...

Informatica mapping question

Asked By: Prabhu_info | Asked On: Oct 8th, 2014

Design mapping to load the first record from a flat file into table a, the last record from a flat file into table b, and remaining record into table C

Answered by: gaja on: Oct 13th, 2014

use two sessions wf--->s1--->s2 1)in 1st session find count using aggregator t/rn then assign it to mapping variable and pass this variable to work flow varible using post session command in sessio...

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

Asked By: cvgopal123 | Asked On: Mar 17th, 2007

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

Answered by: ashish on: 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

Answered by: jayapraveen on: Jun 22nd, 2012

by using Lookup transformation
LKP Logic

in Condition port Salhisal with this Condition we can join two tables

How we can validate all mapping at a time?

Asked By: Ramesh12888 | Asked On: May 26th, 2012

We can validate all mappings in powercenter repository manager window by each folder.

Answered by: Mahendra Rajpoot on: Sep 18th, 2014

Please use this link:

gives step by step appoach

Answered by: lakshmi on: May 27th, 2012

in repository go to menu tool then queries.query browser dialog box will appear.then click on new button. in query editor,choose folder name and object type after that execute it(by clicking the blue...

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: Mahendra Rajpoot on: Sep 17th, 2014

We cannot use Joiner t/r immediately after sequence generator and upd strategy t/r as 1. Joiner will join 2 sources and it cannot join 3rd source as seq generator. Also if we select seq generator as 1...

Answered by: Twinkle on: Jul 25th, 2012

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

What is staging are why we need it

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

Answered by: Mahendra Rajpoot on: 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...

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

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: Mahendra Rajpoot on: Sep 17th, 2014

Yes it is possible. Use left outer join query between source and target table in SQ to achieve look up functionality. Send this output to EXPR and then RTR for condition check SCD 2. Then insert and u...

Answered by: Anupama on: Oct 8th, 2012

We can use SCD without using lookup.

Performace tunning of session and workflow

Asked By: BRAHMAIAH | Asked On: Aug 9th, 2014

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

Answered by: Rajesh Kumar on: 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)

Etl transformation question

Asked By: madhulatha | Asked On: Jul 8th, 2014

Employee name start with a pass to one target,employee name start with s pass to 2nd target,employee name start with j pass to 3rd target,other pass to other target.

Answered by: Sandy on: Aug 31st, 2014

To make current answers generic and mapping applies even if you get more names starting with different characters: Use Sorter, Expression & Transaction control transformations - Using sorter transfor...

Answered by: amrie on: Jul 30th, 2014

In the expression Create a variable port v_employee= IIF( substr(EMPLOYEENAME,1,1)=A,FLAG1 IIF( SUBSTR(EMPLOYEENAME,1,1)=S,FLAG2, IIF( SUBSTR(EMPLOYEENAME,1,1)=J,FLAG3,FLAG4 ))) create a output po...

How do you migrate from one environment to another like development to production in Informatica. Which files do you move?

Asked By: ebrahim | Asked On: Apr 18th, 2007

Answered by: sandeepsandeep on: Aug 11th, 2014

Yes, everything is correct. there is also one other thing, you also have to move parameter files. if you forget your mappings will error out. and also you also need to change the values like dev qat s...

Answered by: Mushi on: Jun 30th, 2014

First - Take a backup and restore of the repository using the Informatica Repository Manager console. Migration can be done at 3 levels: 1.Repository level , 2.Folder level , 3.Object level Steps fo...

Informatica scenerios

Asked By: Madhuri Manchiraju | Asked On: Jul 1st, 2014

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

Answered by: sandeepsandeep on: 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.

Answered by: venkat2ram on: Jul 14th, 2014

This is pretty simple.

Use sequence generator to number the records.

Then sort them in descending order using sorter transformation.

How to remove the null values in flat file ?

Asked By: madhulatha | Asked On: Jul 8th, 2014

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

Answered by: sandeepsandeep on: 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..)

Answered by: poovendhiran on: Jul 16th, 2014

Can we use condition like "not isnull(column name)" in filter transformation and make downstream connection

Why we use lookup transformations?

Asked By: Interview Candidate | Asked On: Sep 20th, 2004

Lookup transformations can access data from relational tables that are not sources in mapping. With lookup transformation, we can accomplish the following tasks:get a related value-get the employee name from employee table based on the employee idperform calculation.Update slowly changing dimension...

Star Read Best Answer

Editorial / Best Answer

Answered by: prodyot Sarkar

Answered On : Jul 31st, 2007

The following reasons for using lookups.....

1)We use Lookup transformations that query the largest amounts of data to improve overall performance. By doing that we can reduce the number of lookups on the same table.

2)If a mapping contains Lookup transformations, we will enable lookup caching if this option is not enabled .
We will use a persistent cache to improve performance of the lookup whenever possible.
We will explore the possibility of using concurrent caches to improve session performance.
We will use the Lookup SQL Override option to add a WHERE clause to the default SQL statement if it is not defined
We will add ORDER BY clause in lookup SQL statement if there is no order by defined.
We will use SQL override to suppress the default ORDER BY statement and enter an override ORDER BY with fewer columns. Indexing the Lookup Table
We can improve performance for the following types of lookups:
For cached lookups, we will index the lookup table using the columns in the lookup ORDER BY statement.
For Un-cached lookups, we will Index the lookup table using the columns in the lookup where condition.

3)In some cases we use lookup instead of Joiner as lookup is faster than joiner in some cases when lookup contains the master data only.

4)This lookup helps in terms of performance tuning of the mappings also.

Answered by: Satya on: Aug 9th, 2014

Use lookup transformation in a mapping to
--get related values
--perform complex calculation
--Handle slowly changing dimension.

Answered by: gazulas on: Apr 22nd, 2009

Thats a good question, suppose say you have 40 transformations in your mapping which invole complex agg, functions,  so in middle of the mapping there is a requirement to get the data from some  x t...

Informatica error - server service starts momentarily and then stops

Asked By: Abhi | Asked On: Aug 13th, 2006

I have installed Informatica 7.1.1 and Oracle.But the Informatica server service starts momentarily and then stops.I have uninstalled and installed Informatica twice and removed from the registry as well, but the problem persists.Does any body have the solution for this

Answered by: krkreddys on: Aug 8th, 2014

It is because of your Repository user is locked/(database not open). Go to oracle database Repository user try to login to repository, then unlock it. It works fine.

Answered by: suvashis on: Oct 12th, 2007

Step1: first install oracleStep2: install Informatica on windows 2000 Step3: configure the Informatica server, repository administrative console. Step4:give correct ip address (note down it)Start th...

Oracle sequence generator

Asked By: krishnaadapa | Asked On: Sep 13th, 2013

How to write stored procedure,which take the sequence name as input and dynamically generates a nextval from that sequence

Answered by: Ashish on: Jul 30th, 2014

"sql Create or Replace Procedure P_Get_Value( seqnm IN Varchar2) Is L_Var Varchar2(100); TYPE cur_typ IS REF CURSOR; c cur_typ; Begin OPEN c FOR SELECT || seqnm || ...

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.