write a query to get maximum salary from the employers table
without duplicates....kindly help me
Answer Posted / sudheer113
MAX(SAL) will not give duplicate records in a single group
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the restrictions of union transformation?
What is DR strategy for Informatica project?
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
Explain dynamic target flat file name generation in informatica
What is informatica powercenter repository?
can u any challenge your project?
What is the difference between stop and abort in informatica
What is Cognos script editor?
What are batches?
What is workflow? What are the components of the workflow manager?
What is blocking transformation?
What is a pre-defined event and user-defined event?
How many types of sessions are there in informatica.please explain them?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?