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 |
What are the ETL tools available in DWH?
What is CDC? How to implement CDC?
Three date formats are there . How to change these three into One format without using expression transformation ?
what are factless facts? And in which scenario will you use such kinds of fact tables.
what is the complex transformation you used in informatica
What is up date strategy and what are the options for update strategy?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
why do we go for update strategy tr in SCD rather using the session properties?
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
what is difference between COM & DCOM?
suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?
how to join the two flatfiles using the joiner t/r if there is no matching port?