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


Please Help Members By Posting Answers For Below Questions

What are the tuning techniques you applied during your last project

1553


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??

551


Mention a few design and development best practices for informatica?

549


Differentiate between source qualifier and filter transformation?

987


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5231






What is confirmed fact in dataware housing?

5660


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1548


How to start a workflow using pmcmd command?

703


What does “tail –f” command do and what is its use as an Informatica admin.

623


How can you validate all mappings in the repository simultaneously?

749


Could you explain what is enterprise data warehouse?

546


what are 3 tech challenges/ common issues you face?

1875


What is rank transformation?

565


Scheduling properties,whats the default (sequential)

1452


Explain what are the different types of transformation available in informatica.

563