Answer Posted / krishnakanth
Hi Sudhar........Thanks for the answer. Its really very
helpful.
| Is This Answer Correct ? | 0 Yes | 1 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
Mention a few design and development best practices for informatica?
What is joiner transformation in informatica?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How does a sorter cache works?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
what are factless facts? And in which scenario will you use such kinds of fact tables.
what is diff b/t sorter t/r and agg have the option sorter property...
How to use procedural logic inside infromatica?
Explain what is informatica metadata and where is it stored?
Explain the types of lookup transformation?
How can informatica be used for an organization?
What is the sql query overwrite in source qualifier in informatica
How to implement security measures using repository manager?
What is informatica metadata and where is it stored?