source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000
Answer Posted / ravikishore
JAMES YOUR ANSWER IS CORRECTIN IN ORACLE,BUT I WANT ANSWER
IN INFORMATICA LEVEL AND UR SOURCE IS FLAT FILE HOW TO DO
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is fact table? Explain the different kinds of facts.
What are the new features of informatica 9.x developer?
Can we override a native sql query within informatica?
What is DR strategy for Informatica project?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
in reporting we add some new objects,how we get the count of the newly added objects to the report
How do you load first and last records into target table?
can anyone explain me about retail domain project in informatica?
What are the mapping parameters and mapping variables?
How many transformations can be used in mapplets.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Explain incremental aggregation in informatica
Can you generate sequence numbers without using the sequence generator transformation?
How does a sorter cache works?
How many number of sessions can one group in batches?