Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
1 4137Diff 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 15405Suppose 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 91063. 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 10538How can u insert o ne row in the target if that row does not exists in the target and update if it exists
6 12732what are the limitations for bulk loading in informatica for all kind of databases and transformations?
3 138261.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 17167when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
5 14230Post New Accenture Informatica Interview Questions
Is there an easier way to change formula results to fixed values in microsoft excel? I usually copy the cells that I am working with and then use the paste specialcommand to past the permanent values over the original formulas?
Write my own zero-argument manipulator that should work same as hex?
List some neo4j commands?
What are the differences between laravel and codeigniter?
Can we have multiple document.ready() function on the same page? : jquery mobile
What is allotrope ? In what forms of cubic pattern, iron exists ?
Explain what type of flow measurement devices is best for slurries?
During the drive torque, what will be the weight shift?
What does ipc class mean?
How long have you been working on mainframes?
How do you flash fill in excel 2016?
Steps for launching a drupal site?
What is the usage of the lattice package in R?
Why do I get EPROTO from read()?
How to find CN by using arcgis 9.3?