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
Answers were Sorted based on User's Feedback
Answer / aravind
Check the session Run properties and session log. This will
show the no. of rows inserted into each target. Also you
can check the target data in the database level
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / naresh
Check the run properties in session logs()workflow
monitor), that how many records are loaded in each target
adn use contrain-based loading will be work out.
| Is This Answer Correct ? | 0 Yes | 0 No |
why we are using surogate key in real time give me explanation
is it possible to index the data in cache of lkp transformation ?
What is aggregate cache in aggregator transforamtion?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Different sorts of metadata that stores in the storage facility?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
What do you mean by enterprise data warehousing?
how to load only the first and last record of a flat file into the target?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Define the various join types of joiner transformation?
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?