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

Informatica Interview Questions

Questions Answers Views Company eMail

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 3300

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2060

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

TCS,

1 3777

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

TCS,

2 4296

explain different levels in pushdown optimization with example?

TCS,

2 7287

waht type of interface is used for testing the data in informatica

CTS, TCS,

2249

wat are deployement groups in informatica, how it will be used for developers

1714

what is the difference between informatica6.1 and infomatica7.1

TCS,

2271

can we use union transformation in joiner transformation?how?

Dabur, Tech Mahindra,

1 9023

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

CTS,

3 8946

how to through logic of informatica using the push down optimization into oracle.

Hexaware,

2 7770

Is there any model difference between ODS and DWH

Zensar,

2 7336

How You Pull the records on daily basis into your ETL Server.

TCS,

2 7094

How IN function works in informatica? Is it similar that of oracle IN function or different? Explain

Mphasis,

2 15068

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

Zensar,

2 6768

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the components of Informatica? And what is the purpose of each?

1053

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2856

Explain constraint based loading in informatica

1091

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1007

Explain what is informatica metadata and where is it stored?

1047

explain abt ur project architecture?

2186

Define pmcmd command?

1037

What does command task mean?

1138

Implementation methodology

1708

Partition, what happens if the specified key range is shorter and longer

2489

Explain the scenario which compels informatica server to reject files?

1162

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2052

How many numbers of sessions can one group in batches?

1061

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4106

if we have a delimiters at unwanted places in a flat file how can we over come those.

2045

For More Un-Answered { Informatica } Questions Click Here