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
- 12574 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / jyothiram
PUT SORTER WITH KEY OF ROWID IN FIRST EXPRESSION FLAG THE
RECORDS WHICH IS HAVING MORE THAN ONCE ,TAKE PRV PORT AS
VARIABLE MATCH IT WITH CURRENT AND SET FLAG OUT ACCORDINGLY,
IN NEXT EXPRESSION CHCEK FOR FLAG, IF IT SETS
DO 'XX'||SUBSTR(ROWID,3) OTHER WISE ROWID ONLY . HOPE THIS
WILL SOVE .
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the use of code page?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What does role playing dimension mean?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is the need of etl tools?
In informatica workflow manager, how many repositories can be created?
How can repository reports be accessed without sql or other transformations?
What are the tasks that source qualifier perform?
what is the size of u r source(like file or table)?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Plz can any one say me how to get the informatica certification materials and dumps
Difference between Target-based loading and constraint-based loading?
What is the difference between a connected look up and unconnected lookup?
Briefly define a session task?
What is the function of aggregator transformation?
