in mapping i have one source and five targets in that data
will be loaded into four targets properily
in one target the data is not loaded how will u rectify
Answer Posted / chow
I think Constrain-baced loading
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In warehouses how many schemas are there?
What are the different types of repositories created using informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Explain the difference between a data warehouse and a data mart?
What do you understand by SOA of Informatica?
How many number of sessions can one group in batches?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
in reporting we add some new objects,how we get the count of the newly added objects to the report
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is the cumulative sum and moving sum?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
When do you use sql override in a lookup transformation?
How many ways are there to create ports?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain the etl program with few examples.