Interested to Buy Any Domain ? << Click Here >> for more details...
how to convert
101 raja 101 raja sekar reddy
101 sekar---------->
101 reddy
- 2 Answers
- 10283 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / purushotham perumalla
Create variable ports in Expression transformation to
concat name if the number is same as follows
Assume the input field names are number and name
define the variable ports in expression transformation in
the following order
v_flag = iif(number = v_number,0,1)
v_name = iif(v_flag = 1,name,v_name ||' '||name)
v_number = number
O_name = v_name
The output of o_name will be as follows
number o_name
----------------
101 raja
101 raja sekar
101 raja sekar reddy
Add an aggregator transformation after expression and group
by number. output number and o_name from aggr to target.
As aggr outputs last row in each group by deault it will
send 101 raja sekar reddy to the output.
| Is This Answer Correct ? | 3 Yes | 0 No |
what is the difference between Informatica7.1 & informatica 8.1
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
Explain joiner transformation in informatica
What is main use of mapplet?
What is diff joiner and lookup
How many ways a relational source definition can be updated and what are they?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
where to store informatica rejected data?
Teradata 
