I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
- 1 Answers
- 3751 Views
- Cipla, Quintiles, I also Faced
- E-Mail Answers
what i understand is when first time run source have two records and it got inserted in target and then source data was deleted and new 10 records were inserted . In this case when you run wf again it will insert 10 records to target then , totally we will have 12 records in target
| Is This Answer Correct ? | 1 Yes | 0 No |
how to work with mapplet designer in informatica?
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
Describe an informatica powercenter?
How do you implement unconn. Stored proc. In a mapping?
what is the process we used in joiner transformation,there is no matching column in sources?
How can we get multiple output values using an unconnected lookup transformation?
what is mapping optimization? wat are the techniques for tat
Where do we use mapping variables in informatica?
What are the different types of code pages available in informatica & how to implement it in your project?
Mention a few design and development best practices for informatica?
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
Teradata 
