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

Informatica Interview Questions
Questions Answers Views Company eMail

what is Active lock explain

Satyam,

1936

What are the different types of code pages available in informatica & how to implement it in your project?

TCS,

1 9058

What is the difference between unicode & ascii mode data movement in informatica?

TCS,

1 10347

What is CDC? How to implement CDC?

People Tech, TCS,

4 18108

Tell me about informatica architecture.

TCS,

2 7828

write a query for how to eliminate the duplicate rows without using distinct?

iGate,

6 8368

how to get the first row without using rank t/r?

iGate,

7 8343

what is the command to get the list of files in a directory in unix?

iGate,

5 6781

Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 6438

what are the row and column separations in Flat Files

CTS,

3 6179

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1058

sample mappings for scd1,scd2 and scd3

Cognizant,

2 18422

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

Patni,

5 8733

what is procedure to use mapping variable in source qualifier transformation? with example

IBM,

1 5547

how to create a sample mapping for dynamic lookup transformation

2 3207


Post New Informatica Questions






Un-Answered Questions { Informatica }

What is the scenario which compels informatica server to reject files?

191


Differentiate between reusable transformation and mapplet.

150


What is a surrogate key?

176


Explain the informatica workflow?

178


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1214






What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

3903


How would you copy the content of one repository to another repository?

193


How to use procedural logic inside infromatica?

185


Write the prerequisite tasks to achieve the session partition?

210


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

229


Define update strategy?

199


As union transformation gives UNION ALL output, how you will get the UNION output?

208


What is the status code in stored procedure transformation?

240


Repository user profiles

933


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1464