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
- 12827 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
How can we use batches?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Describe expression transformation?
What is intricate mapping?
What is transformation?
What are the different types of repositories created using informatica?
What is the cumulative sum and moving sum?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
In development project what is the process to follow for an etl developer from day1
What are the static cache and dynamic cache in informatica?
Does an informatica transformation support only aggregate expressions?
can u any challenge your project?
What is the difference between informatica 7.0 and 8.0?
How big was your fact table
Clarify the aggregator change?
