what is the purpose of surrogate key and diff between primary
It represents one or more fields or attributes that uniquely identified each record in a database table.
surrogate-key:-It is a single part,artificially established identifier an entity,surrogate key assignment is a special case of derived data-one where the primary is derived.A common way that surrogate key values is to assign integer values sequentially.
|Is This Answer Correct ?||5 Yes||1 No|
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
without matching columns in two tables. how can you join
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
how to declare array in plsql?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
How to extract original records at one target & Duplicate records at one target?
I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)
how do u use sequence created in oracle in informatica? Explain with an simple example
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
what are the limitations of pushdown optimization technique ? Advance thanks
What is CHECK-IN CHECK-OUT. Please explane me?