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
- 3 Answers
- 6430 Views
- Patni, I also Faced
- E-Mail Answers
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 |
Does an informatica transformation support only aggregate expressions?
how DTM buffer size and buffer block size are related
what is unit testing?tell me proceedure
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
What is a transaction control transformation?
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
What did you do in source pre load stored procedure
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
how remove 1st 3 records & last 3 records in informatics
Teradata 
