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)
Answer Posted / krishnakanth.ch
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 |
Post New Answer View All Answers
What are multi-group transformations?
what is Active lock explain
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are data-driven sessions?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Explain the difference between a data warehouse and a data mart?
What is a difference between complete, stop and abort?
What is olap (on-line analytical processing?
Scheduling properties,whats the default (sequential)
can you please explain me pre session and post session options?
What is rank transformation in informatica
What are the types of schemas we have in data warehouse and what are the difference between them?
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
Difference between Target-based loading and constraint-based loading?
What is meant by lookup transformation?