Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

IBM,

9119

WHAT IS FACT TABLES?

4571

Could any one to tell How to use the Oracle Analytic functions in Informatica?

10096

Could any one to tell Fact table Partitioning?

4169

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

FCS, IBM, Satyam, TCS,

23250

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

HP,

16144

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

HP, TCS,

15252

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

HP, Patni,

18821

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

HP,

9055

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

HP,

12946

Three date formats are there . How to change these three into One format without using expression transformation ?

HP,

9125

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

39200

In real time scenario where can we use mapping parameters and variables?

CSC, CSE,

28446

From where we can start or use pmcmd?

7142

Whats the difference between \$, \$\$, \$\$\$

38079

What do you mean by filter transformation?

141

What is the procedure for creating independent data marts from informatica 7.1?

143

Explain incremental aggregation in informatica

172

What are the different versions of informatica?

154

What is the advantage of informatica?

136

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1209

What is a mapplet/worklet in informatica?

154

Name the different lookup cache(s)?

138

What is the benefit of session partitioning?

148

How can you validate all mappings in the repository simultaneously?

183

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1026

What are junk dimensions?

155

How you can differentiate between connected lookup and unconnected lookup?

165

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

181

Can we change Dynamic to Static or Persistent cache? If so what happens?

1218