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 |
Explain lookup transformation is active in informatica
what is data modelling? what are types of modelling?In which suituation will use each one?
what is mapping parameter?
What is Micro Strategy? Why is it used for?
Explain constraint based loading in informatica
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
can session assigned multiple mappings or not?
write a query for how to eliminate the duplicate rows without using distinct?
What is the benefit of partitioning a session?
can u any challenge your project?