My source data like...
Empid Name
10 chandra
10 sekhar
I am expecting result is
Empid Ename
10 Chandrasekhar
How can we solve this prob?
Answer Posted / shaik mahamad rafi
first use concatenate operator '',then use union
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to create the source and target database connections in server manager?
What is incremental aggregation?
How can we store previous session logs?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain lookup transformation source types in informatica
Explain why we use partitioning the session in informatica?
Explain incremental aggregation in informatica
What is confirmed fact in dataware housing?
What differs when we choose the sorted input for aggregator transformation?
What is dimensional table?
In warehouses how many schemas are there?
How union transformation is used?
Explain what are the different types of transformation available in informatica.
Write the program through which the records can be updated?
without table how to come first record only in oracle?