Series: Subject:

Informatica FAQ

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

What is the way to add the total number of records that have been read from src in the tgt file as last line?

Asked By: N SRIRAM K | Asked On: Jun 25th, 2007

What is the way to add the total number of records that have been read from src in the tgt file as last line? Let me clear you if my tgt is a flat file and want to add total number of records that are written in tgt as a last line with sysdate.

Answered by: Surbhit on: Apr 1st, 2014

Use an aggregator and do no group by any key

Answered by: Ankit Kansal on: Feb 15th, 2014

Easy way of achieving the functionality is with Unix commands however if you want to achieve it using Informatica only then Then just before dumping your data to your target use aggregator count() f...

Wants to change career into Informatica

Asked By: amit rajora | Asked On: Jan 9th, 2014

Hi my name is amit and I am here to take some career advice. i did bsc (h) cs from delhi university in 2009 and after it I joined a company where my profile was analyst in excel and some basic use of SQL query. I worked there almost 3.8 yrs but due to some personal reasons I quit my job on september...

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: janakiram on: Oct 16th, 2013


Drag Nextval to Exp. Create
O_Dummy 1

Drag Nextval to Agg
O_Count Count(Nextval )
O_Dummy1 1


Nextval=1 and Nextval=O_Count

Connect required ports from Filter to Target

Answered by: priyank_divya on: Sep 16th, 2013

From Source Qualifier transformation, separate 2 pipelines,
1st pipeline, Aggregator transformation to generate the last row(do not use group by)
2nd pipeline, Aggregator transformation with FIRST() command to generate the first row.
Use Union transformation to merge the 2 rows and push to target.

Which one is better between connected and unconnected lookup?

Asked By: reddy | Asked On: Apr 25th, 2006

In lookup which one is better one connected and unconnected lookup?Performance wise I am asking?If I am using five connected lookup in mapping that time what happens?

Answered by: Ganesh kumar on: Sep 4th, 2013

yes, I Agree your answer,.....

Answered by: Baloo_nanduri on: Jul 25th, 2010

Connected lookup lends best performance and also you can cache or uncache connected look up unconnected look up is used only when you have to use it as a function call both have its own benefits, using 5 connected lookup's is not a big deal until your mapping is tuned well.

Delete first 3 rows & last 3 rows in target table

Asked By: jhotsna | Asked On: Feb 17th, 2011

How to delete first 3 rows & last 3 rows in target table in Informatica?

Answered by: priyank_divya on: Aug 28th, 2013

1. SQ 2. Expression --> Connect the expression with the Sequence Generator 3. Aggregator with one column(key column if any) Out_Count=count(*) Dummy_count=1 3. Expressio...

Answered by: priyank_divya on: Sep 3rd, 2012


We can use a sql in the sql override:

select count(1) from
(select * from where rownum<= (select count(1)-3 from )
select * from where rownum<=3)

This query will remove the first 3 and the bottom 3 records.


I hv a requirement ename paymentsa 100a 101a 102b 200b 201b 201should be in the target likea 100,101,102,103b...

Asked By: sreedhar | Asked On: Jan 2nd, 2007

Answered by: priyank_divya on: Aug 28th, 2013

1. Sort based on ename column.
2. in Exp,
3. Aggregator transformation: Pull ename,Out_Value ports from Exp in Step 2.
Group by ename

Hope this helps!!!

Answered by: abraham deng stephen on: Jul 3rd, 2013

Simple use expression transformation and make all the inputs into the date format given. Add a condition like

  2. IIF(IS_DATE(v-DATE),TO_DATE(v_date,dd-mon-yy),Invalid DATE)

This is my idea. It helps you hopefully....thx

Repository services not started

Asked By: Devender Sharma | Asked On: May 2nd, 2013

I have Oracle 9i and windows XP installed on my machine and try to install Informatica 8.6 and after successfully installing client and server try to do all setting in power center administration console and create new repository but repository services are not up and giving error that unable to connect...

Informatica primary server process

Asked By: sahana | Asked On: Nov 28th, 2007

Which is primary server process in Informatica?1.Repository manager 2.Load manager 3.Workflow manager 4.Workflow designer

Answered by: alex on: Apr 29th, 2013

load manager

Answered by: suvashis on: Dec 12th, 2007

"load manager' is the primary process of informatica power center server
"DTM-data transformation manager" is the secondary prcess..

go through the architecture  of informatica power center server..

thank u...

How to join two tables without common columns?

Asked By: dwhin4matica | Asked On: Feb 27th, 2013

Answered by: Vikas Nandal on: Apr 21st, 2013

Create a Dummy Port in both tables and assign same value e.g. 1 to both ports in expression transformation before joiner.
Now in join condition use this dummy port to join both tables.

Answered by: anshuman trivedi on: Mar 3rd, 2013

You join these table using null key.

Pass {} to the key,I am sure it will work.


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.

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

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.



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

When we use only aggregator transformation in our mapping for approx 5 milion records it takes 40-42min time but when we use it with a sorter transformation, the time reduces to 12 -13 min. We have also...

Asked By: Interview Candidate | Asked On: Oct 27th, 2006

Answered by: priyank_divya on: Jul 11th, 2012

When an Aggregator transformation is used without sorter, it stores all the data before performing the grouping operation. But when a sorter is used before aggregator, it sorts all the data before pas...

Answered by: sai on: Feb 14th, 2007

passing data to sorter is time taking why because sorter transf stores whole data in buffer and then sorts based in specified ports.insted of passing data to sorter transf ,sort d data in the sours...

Write a query to retrieve latest records from the target table means if we have used SCD2 version type of dimension, than retrieve the record with highest version no.For eg ...

Asked By: ravi214u | Asked On: Jan 29th, 2007

Answered by: priyank_divya on: Jul 9th, 2012

Sorry for my previous post. I missed a bit of question.

select * from where version in (select max(version) from group by id, loc_no)

Answered by: priyank_divya on: Jul 9th, 2012

select * from where version=(select max(version) from )

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.