How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)
Answer Posted / ramesh
this can achieved using Update statergy
we have option in UPD or Target update override
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is meant by lookup transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is Cognos script editor?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is a sequence generator transformation?
How can we store previous session logs?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is joiner transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Parameter and variable differences
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Explain the etl program with few examples.
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
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is the format of informatica objects in a repository?