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)
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rajendra
Through Dynamic lookup you can handle it very easily.
Is This Answer Correct ? | 3 Yes | 1 No |
First make sure the values are sorted by rowid and passed
to an expression transformaion.Now create a variable port
in the exp. Lets think var1 and make it empty in the
expression .
now compare rowid with var1 by
IIF(VAR1=ROWID,XX||SUBSTR(ROWID,3,3),ROWID)
When the session starts, since initially the var1 is null,
it will be replaced with first rowid. When the second
record is passed, the values will match the required format
of rowid will be passed and remember to pass the value in
the var1 to the next transformation or target.
Hope this will solve.
Please let me if anything is wrong or does not work out.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
what is junk dimension
How to start a workflow using pmcmd command?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
How to do unit testing in informatica?
how can one eliminate dupliacte data with out using distinct option?
what is workflow varible
How do you update the records with or without using update strategy?
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
Differnce between filter and router?
What is the meaning of up gradation of repository?