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

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 13696

What is Factless fact table ???

Satyam, Tech Mahindra,

12 37258

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

CTS, TCS,

8 31504

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 6615

How will u find weather dimension table is big in size of a fact table?

1 5763

How will u pas the data with out debugger?

4 5493

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 11317

I have 1200 records how can u send it in aggregator with good performance issues?

3 7186

what is the logic will you implement to load data into a fact table from n dimension tables?

TCS,

4 16614

Why is meant by direct and indirect loading options in sessions?

4 20258

In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?

4 6152

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

TCS,

8 19601

On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 9525

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 7167

how do u move the code from development to production?

3 17758


Post New Informatica Questions






Un-Answered Questions { Informatica }

How we can create indexes after completing the loan process?

201


What is data movement mode in Informatica and difference between them?

259


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

211


What are the tasks that source qualifier perform?

255


What do you mean by worklet?

239






Explain the different dimensions.

188


What are the restrictions of union transformation?

221


What is main use of mapplet?

232


What can we do to improve the performance of informatica aggregator transformation?

216


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1116


How union transformation is used?

221


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

632


Explain sessions and how many types of sessions are there?

189


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

213


What does role playing dimension mean?

235