Hi, Can someone send me the DWH and Informatica FAQ's at firstname.lastname@example.org Thanks in Advance, preeti1 2691
Diff 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 10187
Suppose 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 5975
How to convert flat file into xml file? How to tune joiner?2 7747
3. 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 6921
what is shared lookup&persistent lookup?4 6700
what are the unix commands to start the wrk flow ?4 7561
What is the difference Between Mapping parameter and variable3 6390
What is update override?1 3958
How can u insert o ne row in the target if that row does not exists in the target and update if it exists6 9393
what are the limitations for bulk loading in informatica for all kind of databases and transformations?3 10084
1.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 14535
how to join the 2 different table with different columns in informatica?5 16802
How to load the source table into flat file target(with columns) in informatica?4 12790
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?5 9506
I am completed diploma in mechanical in 2002, i have 5year experience in materials (purchase) dept,i want to do SAP cource in MM module, i want to know can i complete SAP after diploma cource only, is it usefull to me for further Job opening.
Are Refrigerators & Deep Freezers the Inductive load ? How to calculate the Power Factor & hence the Output Power for them ?
Suppose we prepared pH buffer solution in lab.and calibrate against NIST solution, and same shall going to used upto 30 days. is it possible to stable pH and appearance? suggest?
ioc vs dependency injection?
What are lattice-based cryptosystems ?
What will be the QA roles and responsibilities in Health care stream like BCBS,can someone please explain me any example project regarding health care services in web-based application?
what are the uses of eutectic alloys?
what is a composite error in current transformers, why occurs & in which it will occur i.e, either metering ct/ protection ct
what is the disso medium for tropsiun chloride
In wct limit is Rs.5lac if vendor provide bill below 5lac wct will applicable or it aggregate I need deduction of wct 5lac slap
Limitations in QTP?
when qty of cable being purchased is not sufficient according to the standard,what should the inspector do to ensure its quality according to the standard?
can we do database testing in manual testing? then how we write the test case?
Why a capacitor is a voltage sensitive device?
What is Sampling for length measurements?