can we load the data with out a primary key of a table?
what is target plan?
Answer Posted / koti
by using update overide option we can update the target
though we dont have any primary key in target.
target overload means some time in a single mapping no. of
targets can take place one source can be depend on other
target. then we have to decide which target has to execute
first....
ex: source1.... target1(date of birth is one column in
target 1)
source2(age is one column is source2).... target2
in the above example target1 should be execute first. then
only we can get age in source 2. because age is depends on
date of birth which is available is target1...
hope u understood. if any clarification mail to me:
manjulakoteswararao@gmail.com
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the Rank index port in Rank transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Can we override a native sql query within informatica?
is it possible to index the data in cache of lkp transformation ?
What is depict expression change?
Explain what are the different versions of informatica?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How many ways are there to create ports?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is a filter transformation?
How can we remove the duplicates from flat file source?
Enlist few areas or real-time situations where informatica is required.
What are the types of data warehouses?
Explain the different dimensions.
Why union transformation is an active transformation?