Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 9632 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Follow the below step.
1.Take the sorter transformation and sort by empid(IF some cases empid not in sequence).
2.Take a expression transformation with below condition.
a. CURRENT_ID=EMPID
b. EMPID=EMPID
C. name=name
d. NAME_VAR= IIF(CURRENT_ID = NEXT_ID,(NAME_VAR ||name ),name)
e.NAME_OUT= NAME_VAR
f. NEXT_ID= CURRENT_ID
3.Take a aggregator transformation and give group by port as empid.
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / shaik mahamad rafi
first use concatenate operator '',then use union
| Is This Answer Correct ? | 0 Yes | 2 No |
What are roles and groups and benefits of using them?
What is deployment group?
can we override a native sql query within informatica? Where do we do it?
Two Default User groups created in the repository are ____ and ______
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
What is the main difference between a Joiner Transformation and Union Transformation?
What are differences between Informatica 7.1 and 6.1
Explain incremental aggregation in informatica
What is the difference between Power Centre and Power Mart?
Which is better performance wise database or file?How?
What are the conditions needed to improve the performance of informatica aggregator transformation?
what is diff between IN and EXIT commands
Teradata 
