SOURCE
NAME SAL
GANGA 30000
RAJU 20000
PAVAN 25000
TARGET
NAME SAL MAXSAL
GANGA 30000 30000
RAJU 20000 30000
PAVAN 25000 30000
in mapping level how to achive that
Answer Posted / davankumar
select name,sal,(select max(sal) from t1) from t1
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to do unit testing in informatica?
Can we get 1st record through Informatica(without sequence number).
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?
What is the maplet?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is a transaction control transformation?
What is the function of look up transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How can we remove the duplicates from flat file source?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
permutations of mapplet
What are the various types of transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is informatica? Why do we need it?
On which transformations you created partitions in your project?