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
Explain sessions. Explain how batches are used to combine executions?
Write the different tools in the workflow manager?
How to convert multiple rows to single row (multiple columns) in informatica
Design a mapping to load the cumulative sum of salaries of employees into target table?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Explain pushdown optimization $pushdownconfig parameter - informatica
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Write the unconnected lookup syntax and how to return more than one column.
In how many ways we can create ports?
What are the main issues while working with flat files as source and as targets ?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How to load the data from a flat file into the target where the source flat file name changes daily?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is primary and backup node?
explain one complex mapping with logic? sales project?