In my sourse i have like
ename,gender
vasu,male
geetha,female
ram,male
suma.female
kesav,male
in my output i need
male,female
vasu,geetha
ram,suma
kesav
Answer Posted / suri
Write the condition based on the gender . so that all males
comes one side and females come another side
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What does update strategy mean, and what are the different option of it?
What is the scenario which compels informatica server to reject files?
What can we do to improve the performance of informatica aggregator transformation?
What is informatica?
Explain pushdown optimization and types in informatica
How to generate sequence numbers using expression transformation?
explain about unit testing? in real time?
What are the informatica performance improvement tips
What are the performance considerations when working with aggregator transformation?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is the need of an ETL tool?
How do you load unique records into one target table and duplicate records into a different target table?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?