Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

Can we create out put ports in source qualifier t/r?

TCS,

5 15250

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

Cap Gemini,

5 9320

hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 4458

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 4813

what is SDLC way of code development?

1982

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

Cap Gemini, CTS,

6 15100

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

Cap Gemini, Cognizant,

2688

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

Bosch,

2088

What is the difference between Bulk Load and Normal Load

TCS,

3 13012

What is limitations of truncate and load option

Cap Gemini,

1 9874

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

Cap Gemini,

10 14098

Design a mapping to get year of join for each employee.

Accenture,

4 9364

Can we combine a flatfile and a database table using an UNION transformation?

Accenture,

2 12741

Difference between STOP & ABORT in Informatica.

Accenture, Wells Fargo,

3 11391

What are the types of error logs available in Informatica?

1 6198

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the databases that informatica can connect to windows?

1009

tell me about your project functionality

2309

Enlist some properties of sessions.

1031

How many transformations can be used in mapplets.

1887

permutations of mapplet

2469

Where do we use mapping variables in informatica?

1008

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2086

define galaxy repository in informatica

2170

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1863

Describe data concatenation?

1022

Suppose we do not group by on any ports of the aggregator what will be the output?

998

What is the Process to creating lookup transformation in informatica

995

Differentiate between a database and data warehouse?

1099

Target increases every day even though no new record was inserted

1524

Why is sorter an active transformation?

1066

For More Un-Answered { Informatica } Questions Click Here