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 3306

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

2065

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 3780

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

TCS,

2 4304

explain different levels in pushdown optimization with example?

TCS,

2 7291

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

CTS, TCS,

2256

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

1719

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

TCS,

2274

can we use union transformation in joiner transformation?how?

Dabur, Tech Mahindra,

1 9032

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

CTS,

3 8948

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

Hexaware,

2 7775

Is there any model difference between ODS and DWH

Zensar,

2 7342

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

TCS,

2 7100

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

Mphasis,

2 15070

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 6770

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain informatica architecture - version 8 / 9

1087

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

9131

How do we call shell scripts from informatica?

1118

How might one distinguish in the case of mapping is right or not without associating session?

1119

What is informatica powercenter repository?

1201

Differentiate between source qualifier and filter transformation?

1578

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1795

Name the different lookup cache(s)?

1233

What are active transformations.

1654

How does a rank transform differ from aggregator transform functions max and min?

1204

How big was your fact table

1803

How to start a workflow using pmcmd command?

1250

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1203

Explain the mapping variable usage example in informatica

1157

How might you approve all mappings in the archive all the while?

1018

For More Un-Answered { Informatica } Questions Click Here