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 does cheating measurement mean?
How is union transformation utilized?
What is the Rank index port in Rank transformation?
Can u generate reports in Informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the need for an etl tool?
What are the different lookup cache(s)?
Explain pmcmd command usage in informatica
What is fact table? Explain the different kinds of facts.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Explain lookup transformation in informatica
Please let me know how to make Data masking in informatica..
What do you mean by worklet?
What is the Process to creating lookup transformation in informatica