How can you recognise whether or not the newly added rows in
the source r gets insert in the target ?
- 2 Answers
- 7948 Views
- I also Faced
- E-Mail Answers
Answer Posted / atiric software(raja)
by flag value we can identify the newly inserted rows
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we create two repositories on same database instance in oracle?
difference between informatica 8.1.1 and 8.6
r u done any partitions in ur project?
Mention few power centre client applications with their basic purpose?
In warehouses how many schemas are there?
How identifying bottlenecks in various components of informatica and resolving them?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is substr in informatica?
Explain scd type 3 through mapping.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Write the unconnected lookup syntax and how to return more than one column.
How you know when to use a static cache and dynamic cache in lookup transformation?
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
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
