Can we update a target table (without primarykey) by using
update strategy transformation?
Answer Posted / mithilesh kumar rai
With Same logic with Update Strategy tr,
just Select Primary Key Option in Target Table Definition.
It will work without defining the Target table.
Regards
Mithilesh Kumar Rai
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Enlist the advantages of informatica.
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Can anyone tell me the new features in Informatica 9 Version?
What are the informatica performance improvement tips
How many ways a relational source definition can be updated and what are they?
What's the layout of parameter file (what does a parameter file contain?)?
What is aggregate cache in aggregator transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
is it possible to index the data in cache of lkp transformation ?
How we can create indexes after completing the load process?
According to his methodology what all you need before you build a datawarehouse
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
can anyone suggest best free Talend data integration training online
Enlist the various types of transformations.
How can informatica be used for an organization?