Informatica Interview Questions
Questions Answers Views Company eMail

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1214

EXL informatica Questions

1122

Major difference between SQL override and Lookup Sql override

1 3634

What are the reusable transformations?

Informatica,

855

What is the maplet?

Informatica,

791

Explain incremental aggregation in informatica

Informatica,

845

How to generate sequence numbers without using the sequence generator transformation?

Informatica,

849

What is rank transformation in informatica

Informatica,

908

How to improve the performance of a session using sorter transformation?

Informatica,

889

How to generate sequence numbers using expression transformation?

Informatica,

810

What is Index Caches size?

Informatica,

829

What is Session and Batches?

Informatica,

852

Explian the connected and unconnected lookup transformation

Informatica,

1 1149

What is the Rank index port in Rank transformation?

Informatica,

832

What are mapplets? How is it different from a Reusable Transformation?

Informatica,

827


Post New Informatica Questions

Un-Answered Questions { Informatica }

Describe an informatica powercenter?

786


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 .

1676


What is the use of code page?

766


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9414


What is the difference between Active and Passive transformation?

835






Please let me know how to make encryption and decryption with example?

1662


Explain sessions and how many types of sessions are there?

770


Explain direct and indirect flat file loading (source file type) - informatica

1054


what is the hint? how to use it to reduce the query processing in program?

7031


Different sorts of metadata that stores in the storage facility?

754


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

3754


lookup transformation with screenshots

3752


Explain the code page compatibility?

816


Explain dynamic target flat file name generation in informatica

816


What are the differences between a connected lookup and unconnected lookup?

810