Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
1 4990Diff 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 17758Suppose 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 106323. 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 12818How can u insert o ne row in the target if that row does not exists in the target and update if it exists
6 14885what are the limitations for bulk loading in informatica for all kind of databases and transformations?
3 152181.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 18115when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
5 16428Post New Accenture Informatica Interview Questions
How to Align maximized forms?
Why does JComponent have add() and remove() methods but Component does not?
Please find below tickets...if anybody has idea about the solutions plz giv answer ASAP.. · Leave Encashment Calculation for Trainee · On-Line Test · Disability Infotype · Balances in SAP HR module is not reconciliation · Change of State of HQ's · 1-NDFL form · ESOP – capture of Grants; Vesting and Ex · Need to modify the programe ZVENDOR_BLOC · Online Assessment Tool - Modifications · Issue in Leave quota generation · New Income Tax slab Rates-VR Payment · Unable to add absence quota balances · Grant on Child care in HR · Vacation compensation after employee left · Issues with Initial Set-up · file cannot be downloaded in speadsheet, · Bifurcating Payroll Area · Ptax Calculation · Leave quota is not displaying in Portal
how to protect motor in dol starter having capacity of 30 hp.40 hp?
What are the different types of equipments for the conveyance of solids?
What are biomass pyramids? What do they represent?
What are the advantages and disadvantages of embedded system?
I need BHEL Engineer Trainee written test papers in Mechanical stream.
What is the difference between splunk app and add-on?
What are primary elements of measuring pressure?
What is yield return in c#?
How do you avoid cyclic imports without resorting to imports in functions?
Explain importance of solanaceae?
How do you test a method for an exception using junit?
What are some of the sub-disciplines within the field of geology?