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 / srinivas.medagum
When i used SQ..>EXPRESSION T/R...>ROUTER...>UNION...>TRG
I AM GETTING OUTPUT ,BUT NOT IN PROPER LIKE
MALE,FEMALE
VASU
RAM
KESAV
SEETHA
SUMA
CAN I USE TWO TARGETS , HOW CAN GET IN PROPER WAY?
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain what transformation and how many are there in informatica?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Explain how many types of dimensions are available in informatica?
Explain about Informatica server process that how it works relates to mapping variables?
What are the components of workflow manager?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is a predefined event?
write a query to retrieve the latest records from the table sorted by version(scd)
have u done any performance tuning? how u ll do?
tell me the rules and responsblites in our project(my project is development)
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
what is SDLC way of code development?
Explain the types of lookup transformation?
server hot-ws270 is connect to Repository B. What does it mean?