Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
1 4352Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
6 15956Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
5 94553. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
7 11025How can u insert o ne row in the target if that row does not exists in the target and update if it exists
6 13180what are the limitations for bulk loading in informatica for all kind of databases and transformations?
3 141361.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
2 17396when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
5 14691Post New Accenture Informatica Interview Questions
How do I run a bash script in linux?
How can we create pie chart in asp.net?
why in an industry; machine having rated 200 h.p stopped after power factor is maintained above 0.97 lag by control panel in view-of energy saving
write code for inserting and updating recoards in sql server database using connected architecture & records shoulds displayed in grid view ( use c# )
What is meant by console programming?
How to combine two formulas in excel?
What are different ways that you can specify the layout of elements in a uiview?
what precautions to be taken while desigining a LT,HT panel. Eg-LT panel PCC panel with ACB installed. HT panel VCB panel with VCB installed. & what is main diffrence betwn IP54 & IP55 construction of panel.
What are the advantages of paper records?
When should need to value a company using a revenue multiple vs. Ebitda?
Is depreciation a expense or income?
Explain the differences between ActiveX Dll and ActiveX Exe?
On a system with paging, a process cannot access memory that it does not own why? How could the operating system allow access to other memory? Why should itor should it not?
What is microsoft visual c++ 2013 redistributable?
What are the motivational factors for you at work?