Answer Posted / ahalya inturi
constraint based load order defines the order in which data
loads into the multiple targets based on primary key and
foreign key relationship.
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
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
Can we get 1st record through Informatica(without sequence number).
Write the program through which the records can be updated?
Why do you use Mapping Parameter and mapping variable?
Difference between Target-based loading and constraint-based loading?
What are the measure objects?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Explain sql transformation in script mode examples in informatica
How to open an older version of an object in the workspace?
what is INFORMATICA TESTING process
What is the session task and command task?
While migrating the data from one environment to another environment how would you manage the connections?
What is the difference between writing a joiner query in ANSI style and THETA style?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the tasks that can be performed using sq?