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 song in infrmatica...?
What is target designer and target load order?
Is it possible to define a single node as a Gateway node as well as worker node?
Explain what are the different versions of informatica?
How to generate sequence numbers using expression transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How we can use union transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Enlist few areas or real-time situations where informatica is required.
which one is better performance wise joiner or look up
What the difference is between a database, a data warehouse and a data mart?
generate date / time dimension in informatica
Explain the code page compatibility?
What are the static cache and dynamic cache in informatica?
What is mapplet in informatica?