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
Enlist the various types of transformations.
How to go to the older version for a mapping?
What is repository manager?
where to store informatica rejected data?
Is there any way to read the ms excel datas directly into informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is the cumulative sum and moving sum?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are Dimensional table?
What does role playing dimension mean?
design of staging area?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is a rank transform?
What are the different components of powercenter?