Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
1 5047Diff 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 17881Suppose 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 107383. 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 12936How can u insert o ne row in the target if that row does not exists in the target and update if it exists
6 14996what are the limitations for bulk loading in informatica for all kind of databases and transformations?
3 152911.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 18186when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
5 16535Post New Accenture Informatica Interview Questions
Explain how the use of shutdown can improve client performance.
What is the difference between asp and aspx?
Explain short brief on Facades in Laravel ?
What is dynamo?How it works and what is the function of dynamo in a DG.
What is Server in SAP terminology?
Greeting to all members, How to calculate spill current when we have different ratio CT and Class for REF(Low Imp) I have 500/1A 5P20 @line side n 400/1A CL.X @ Neutral.
A dd statement consists of 4 fields. Name them?
What is the purpose of the ale pin?
How is the indent amount customized?
Name the different types of pop up boxes in Javascript?
Why do people use windows server?
which transform is better? haar or hadamard
Is mongodb a documentdb?
What is entity bean in ejb?
Some general discussion about my resume.