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

Informatica Interview Questions

Questions Answers Views Company eMail

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

Zensar,

1 7154

How you count the number of records available at your source?

Zensar,

3 14346

How you load distinct records into one target and duplicate records into another target?

Mphasis,

3 16628

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

HP,

5 11410

write a query to get maximum salary from the employers table without duplicates....kindly help me

CTS,

5 10065

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

TCS,

3 7260

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

HP,

3 9065

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

Qwest,

1 5893

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

CTS,

2 13982

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

CTS,

8 14967

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

Cap Gemini,

11 31957

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

TCS,

3 6453

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

Keane India Ltd,

5 9158

What are the different caches used in informatica?

UST,

3 7242

If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

Hexaware,

1 6673

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1012

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

1058

Briefly define reusable transformation?

1131

Did u used latest transformations of 8.6.0? for what?

1882

State the limitations where we cannot use joiner in the mapping pipeline?

1067

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2158

Explain how many types of dimensions are available in informatica?

1098

What is the sql query overwrite in source qualifier in informatica

1090

What is the need for an etl tool?

1068

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

998

my source is junk data how will u remove that junk data by using unix please any one replay me

3704

How you can differentiate between connected lookup and unconnected lookup?

1062

What are active and passive transformations?

1086

what are 3 tech challenges/ common issues you face?

2346

Scheduling properties,whats the default (sequential)

1955

For More Un-Answered { Informatica } Questions Click Here