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
- 4104 Views
- Cipla, Quintiles, I also Faced
- E-Mail Answers
Answer Posted / kamleshmishra291
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 |
Post New Answer View All Answers
Which means the first record should come as last record and last record should come as first record and load into the target file?
What do you understand by a term domain?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are roles and groups and benefits of using them?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is a router transformation?
what are the Methods For Creating Reusable Transformations?
can we override a native sql query within informatica? How do we do it?
How to load last n records of file into target table - informatica
What are the various types of transformation?
Which is the t/r that builts only single cache memory?
State the limitations where we cannot use joiner in the mapping pipeline?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How do you load first and last records into target table?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
