GeekInterview.com
Series: Subject:

Informatica FAQ

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

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

hi..
"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...
suvashis

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.

Regards,
Anshuman

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

Hi,

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:

c:Informatica9.0.1serverinfa_sharedSrcFiles

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

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: Sep 3rd, 2012

Hi,

We can use a sql in the sql override:

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

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

Thanks

Answered by: sridkaretl on: Oct 21st, 2011

As i have mentioned previously first sort the table using sorter transformation and then use rank transformation. next by using expression transformation you can delee all rows as asked in question.

Sorry, if i am wrong. Please correct me.

Regards,
Karthik

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: priyank_divya on: Aug 7th, 2012

Hi,

This can be achieved using an Aggregator transformation.

In the aggregator transformation, check the group by columns for all the source columns and add one extra output port in the aggregator.

OUT_TTL_RECORDS=count(*)

Pass this port value as the last record of the flat file target.

Thanks.

Answered by: Amritendra kumar on: Feb 29th, 2008

yes we hav to take lookup of target table. then follow the scd

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.

Cheers
Arun

Informatica

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 )

How do you take only duplicate rows in target table in Informatica

Asked By: ravi214u | Asked On: Feb 26th, 2007

Answered by: priyank_divya on: Jul 9th, 2012

Hi, One way of getting only the duplicate columns loaded in the target table is to modify the SQ query: When primary keys are defined: select * from where exists (select PK1,PK2,... from group b...

Answered by: koustav on: Jul 31st, 2007

i think you can write the sql query (delete from....) in session post-sql command and it will work good.

How do you recover a session or folder if you accidenTALLY dropped them?

Asked By: sarita | Asked On: Apr 23rd, 2007

Answered by: priyank_divya on: Jul 9th, 2012

If we drop any sessions accidentally, it wont be deleted permanently until we do a check in. So if we want to recover the session, we can do a undo checkout on the session.

Answered by: N SRIRAM K on: Jun 1st, 2007

If you dropped your session or folder we can get it back if it has proper backup.we can also get it back when you have same folders in other environment, I mean to say, generally, we will have th...

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: priyank_divya on: Jul 9th, 2012

It can be done using a setvariable function. We need to add a mapping variable with the initial value given as 0.

Then in the expression transformation:
1. Seq_No -->
2. Out_Seq_No --> setvariable(,)

At every run, the value of the mapping variable will be incremented by 1.

Thanks.

Answered by: Anil kumar on: Oct 19th, 2007

By using pre SQL in source qualifier we can generate sequence in the target

OR
It can be implemented throuh Lookup Transformation, Develope the lookup transformation with condition like NEXTVAL=CURVAL+1, Through this conditon we can acheive.

How do to detect every day delta changes?

Asked By: lucky | Asked On: Nov 21st, 2007

Answered by: priyank_divya on: Jul 9th, 2012

Hi,

We can capture the delta changes by using a look up transformation followed by an update strategy transformation with which can insert,delete and update records.

Thanks.

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

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.