Interested to Buy Any Domain ? << Click Here >> for more details...
On a day, I load 10 rows in my target and on next day if I
get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert
and update the record?
- 6 Answers
- 13444 Views
- I also Faced
- E-Mail Answers
Answer Posted / sid
take a look t/f and a update strategy t/f. basing on look
up , if the record exits in target then reject it ,if not
exit insert it,and if the record exist but it is changed
then update it
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is incremental aggregation?
What is xml source qualifier transformation in informatica?
what is index?how it can work in informatica
What is mapplet in informatica?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
what is INFORMATICA TESTING process
Whats the difference between informatica powercenter server, repositoryserver and repository?
Differentiate between a database and data warehouse?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What are the types of lookup transformation?
can we override a native sql query within informatica? Where do we do it?
Explain how to import oracle sequence into informatica?
What is rank transformation?
