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
How you prepared reports for OLAP?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Explain the shared cache and re-cache?
In informatica workflow manager, how many repositories can be created?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is the difference between a connected look up and unconnected lookup?
What are the components of the workflow manager?
What is rank index in rank transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
EXL informatica Questions
Design a mapping to load a target table with the following values from the above source?
Explain the features of connected and unconnected lookup.
Whats there in global repository
What all are steps in up gradation of Informatica server?