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
When do you use sql override in a lookup transformation?
Explain the etl program with few examples.
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
what is song in infrmatica...?
What is primary and backup node?
what are the Methods For Creating Reusable Transformations?
What are the main features of Oracle 8i with context to datawarehouse?
What are roles and groups and benefits of using them?
How to use procedural logic inside infromatica?
Define mapplet?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How do you use reject loader.
While migrating the data from one environment to another environment how would you manage the connections?
What are the popular informatica products?