Informatica Interview Questions
Questions Answers Views Company eMail

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

TCS,

5 13498

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 7747

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 3843

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 4209

what is SDLC way of code development?

1536

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

Cap Gemini, CTS,

6 13048

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,

2274

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,

1661

What is the difference between Bulk Load and Normal Load

TCS,

3 11468

What is limitations of truncate and load option

Cap Gemini,

1 8524

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

Cap Gemini,

10 11916

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

Accenture,

4 7995

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

Accenture,

2 11486

Difference between STOP & ABORT in Informatica.

Accenture, Wells Fargo,

3 10183

What are the types of error logs available in Informatica?

1 5478


Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain informatica architecture - version 8 / 9

640


How to load the data from people soft hrm to people soft erm using informatica?

533


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1442


Why is sorter an active transformation?

637


How big was your fact table

1293






How does the aggregator transformation handle null values?

678


What is the benefit of session partitioning?

573


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

603


How do you promote a non-reusable transformation to reusable transformation?

641


What is the use of code page?

567


What are the new features of informatica 9.x developer?

511


What is a shortcut and copy in Informatica and how two are different with each other?

652


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1625


What is aggregate cache in aggregator transformation?

611


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

591