How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Mention a few design and development best practices for informatica?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
Mention some types of transformation?
Explain joiner transformation in informatica
what is normalization? explain 1st NF, 2nd NF, 3rd NF
what is diff between grep and find
how can we check whether a particular cache is static or dynamic?
What is the default source option for update stratgey transformation?
Enlist the various types of transformations.
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution