How can you recognise whether or not the newly added rows in
the source r gets insert in the target ?
Answer Posted / swetha
In the Type2 maping we have three options to recognise the
newly added rows
Version number
Flagvalue
Effective date Range
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what is degenerated dimension?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Enlist the differences between database and data warehouse.
Briefly define a session task?
What is a filter transformation?
How many ways are there to create ports?
What are the different types of olap? Give an example?
Why do you use Mapping Parameter and mapping variable?
Explain the types of lookup transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
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
How many number of sessions can one group in batches?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Explain lookup transformation is active in informatica
What are the different versions of informatica?