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
- 12825 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
Explain why we use partitioning the session in informatica?
can we override a native sql query within informatica? Where do we do it? How do we do it?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is workflow manager?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Explain the mapping variable usage example in informatica
Mention a few design and development best practices for informatica?
During the running session, output files are created by informatica server. Enlist few of them.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Enterprise data warehouse your projects phase by phase explain?
How can we use batches?
What is InformaticaPowerCenter?
What are the issues you have faced in your project? How did you overcome those issues?
