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
- 12837 Views
- iFlex, I also Faced
- E-Mail Answers
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 |
lookup transformation with screenshots
Which gives the more performance when compare to fixed width and delimited file ? and why?
How do you load unique records into one target table and duplicate records into a different target table?
i have 2 session s1 execute s2 load first session fail what is the reason?
What is meant by lookup transformation?
can we load the data with out a primary key of a table? what is target plan?
Can a joiner be used in a mapplet.
What is enterprise data warehousing?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is the sql query overwrite in source qualifier in informatica
What is parameter file?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
Teradata 
