Hi, Can someone send me the DWH and Informatica FAQ's at firstname.lastname@example.org Thanks in Advance, preeti1 3092
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 11808
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 6676
How to convert flat file into xml file? How to tune joiner?2 8376
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 7783
what is shared lookup&persistent lookup?4 7452
what are the unix commands to start the wrk flow ?4 8446
What is the difference Between Mapping parameter and variable3 7254
What is update override?1 4546
How can u insert o ne row in the target if that row does not exists in the target and update if it exists6 10321
what are the limitations for bulk loading in informatica for all kind of databases and transformations?3 11475
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 15523
how to join the 2 different table with different columns in informatica?5 18396
How to load the source table into flat file target(with columns) in informatica?4 13975
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?5 11025
What is bookmark in ms word?
Explain the difference between angular.js and backbone.js?
what are important lanfree parameters to be added in dsm.sys?
What do you mean by cloudstorming?
How hive can improve performance with orc format tables?
If company invest Rs. 3,00,000 in Chit & Fund and later received with Profit Rs. 3,50,0000 = (Rs. 3,00,000 + 50,000 profit amount). Pls advise how to pass the profit amount...and in which head the profit amount goes
What data formats does Redshift Spectrum support?
I would like to know some real time questions.. please any one help me.. If the changes made by you .. lead to system inconsistency how others will know its cause???
What is vlookup used for?
Can we have more than one package statement in source file ?
Can an array be null c#?
What is a dao layer in java?
HOW MANY ACCOUNTING STANDARDS ARE PREVAILING IN INDIA AS DECLARED BY ICAI
Short Answer on __________Trade
Which MRP types you have used?