I have a flat file, in which i have two fields, emp_id,
emp_name. The data is like this,
emp_id,emp_name
101,soha
101,ali
101,khan
102,siva
102,shanker
102,reddy.
how to merge the names so that my output is like this
Emp_id Emp_name
101 Soha ali kahn
102 siva shenkar reddy
please provide solution
Answer Posted / shirish
In expression transformation use an output port ...in
expression window write emp_id||empname
| Is This Answer Correct ? | 7 Yes | 15 No |
Post New Answer View All Answers
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What are roles and groups and benefits of using them?
Is it possible to create multiple domains on a single Informatica server?
What is the difference between a connected look up and unconnected lookup?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Mention some types of transformation?
How to load data in informatica ?
What are the differences between a connected lookup and unconnected lookup?
As union transformation gives UNION ALL output, how you will get the UNION output?
can u give example for factless fact table
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
what is the Default Source Option For Update Strategy Transformation?
Briefly describe lookup transformation?
Difference between Data and Index Caches?