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 are the tuning techniques you applied during your last project
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Mention a few design and development best practices for informatica?
Differentiate between source qualifier and filter transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is confirmed fact in dataware housing?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How to start a workflow using pmcmd command?
What does “tail –f” command do and what is its use as an Informatica admin.
How can you validate all mappings in the repository simultaneously?
Could you explain what is enterprise data warehouse?
what are 3 tech challenges/ common issues you face?
What is rank transformation?
Scheduling properties,whats the default (sequential)
Explain what are the different types of transformation available in informatica.