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 / gangadhar799

orcle level you are 100% correct but in informatica level
how to configure mapping

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain dynamic target flat file name generation in informatica

652


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6485


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

609


Explain the shared cache and re-cache?

615


Difference between Target-based loading and constraint-based loading?

557






How many input parameters can exist in an unconnected lookup?

1003


What will be the approach?

584


What is a filter transformation?

574


What is different between the data warehouse and data mart?

630


What is meant by LDAP users?

699


Enlist the advantages of informatica.

633


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1560


What is a repository manager?

650


What is status code in informatica?

588


How we can create indexes after completing the loan process?

730