Interested to Buy Any Domain ? << Click Here >> for more details...
if i have records like these
(source table)
rowid name
10001 gdgfj
10002 dkdfh
10003 fjfgdhgjk
10001 gfhgdgh
10002 hjkdghkfh
the target table should be like these by using expression
tranformation.
(Target table)
rowid name
10001 gdgfj
10002 dkdfh
10003 fjfgdhgjk
xx001 gfhgdgh
xx002 hjkdghkfh
(that means duplicated records should contain XX in there
rowid)
- 5 Answers
- 13037 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / mfg
create an output port and write the expression to replace
values or create a stored procedure and call it expression
transformation
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the different ways to implement parallel processing in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How do you update the records with or without using update strategy?
How do you take back up of repository?
What is the difference between router and filter?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is a transaction control transformation?
How to delete duplicate row using informatica?
I have a flat file, want to reverse the contents of the flat file
how to load dimension table and fact table. plz tell me the steps.
How are indexes created after completing the load process?
