how to get the first row without using rank t/r?
Answer Posted / gandra krishna reddy
by using first function in aggregator transformation.
| Is This Answer Correct ? | 5 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
Write the unconnected lookup syntax?
How can we use mapping variables in informatica? Where do we use them?
Tell me about MD5 functions in informatica
Where is metadata stored?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Plz can any one say me how to get the informatica certification materials and dumps
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Different sorts of metadata that stores in the storage facility?
Why update strategy and union transformations are active? Explain with examples.
Differentiate between sessions and batches?
What is a shortcut and copy in Informatica and how two are different with each other?
What is a stored procedure transformation?
What are the popular informatica products?
Which transformation is needed while using the Cobol sources as source definitions?