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
- 9835 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / santosh
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 |
Post New Answer View All Answers
Explain scd type 3 through mapping.
Explain direct and indirect flat file loading (source file type) - informatica
what is size of u r database?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Briefly describe lookup transformation?
What is the use of target designer?
What is joiner change?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How do you load unique records into one target table and duplicate records into a different target table?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the new features of informatica 9.x at the developer level?
What is resilience time?
What do you mean by enterprise data warehousing?
How can you define user defied event?
