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
Which is the t/r that builts only single cache memory?
Differentiate between a database and data warehouse?
Reusable transformation and shortcut differences
How to extract sap data using informatica?
How do you set a varible in incremental aggregation
Why sorter is an active transformation?
Explain Dataware house architecture .how data flow from intial to end?
can we override a native sql query within informatica? How do we do it?
Explain lookup transformation in informatica
What will be the approach?
What is the need of an ETL tool?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How to generate sequence numbers?
What do you mean by blocking transformation?
How do you migrate data from one environment to another?