Hi, Can someone send me the DWH and Informatica FAQ's at firstname.lastname@example.org Thanks in Advance, preeti1 3829
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 14435
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 8453
How to convert flat file into xml file? How to tune joiner?2 9711
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 9717
what is shared lookup&persistent lookup?4 8975
what are the unix commands to start the wrk flow ?4 10235
What is the difference Between Mapping parameter and variable3 8539
What is update override?1 5441
How can u insert o ne row in the target if that row does not exists in the target and update if it exists6 12068
what are the limitations for bulk loading in informatica for all kind of databases and transformations?3 13231
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 16739
how to join the 2 different table with different columns in informatica?5 21254
How to load the source table into flat file target(with columns) in informatica?4 15527
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?5 13201
Post New Accenture Informatica Interview Questions
what is INFORMATICA TESTING process
What is the most efficient way to store flag values?
What is the purpose of form-beans tag in struct-config.xml?
Stochastic hill climbing chooses at random from among the uphill moves; the probability of selection can vary with the steepness of the uphil1 move. a) True b) False
What methods did you use to prioritize work assignments?
fiscal year variant Vs posting period variant
Why must we pay attention when we drain steam in steam turbine. What factors are observed?
Hybris is built over the concepts of extensions. Each extension has its own data model. Any extension can use an item type from other estio extension and extend it as per requirement. Can you give an example?
What is insert in ms word?
What is the use of inet_aton() Function?
What is distutils?
How to end the current transaction in oracle?
Can we distribute my web signals application?
please give the remaining answers.
What are Tags?