scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S
output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
Answer Posted / kumar
Use a variable to hold "emp_nem" Like
V1=emp_nem
V2=v1
o/p V2||v1
this is will give the desired output.
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
How to load last n records of file into target table - informatica
Performance tuning in UNIX for informatica mappings?
What is expression transformation?
Name the different lookup cache(s)?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Explain in detail scd type 2 through mapping.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Is it possible to use a client with different version than that of its Informatica server?
How we can create indexes after completing the load process?
How many transformations can be used in mapplets.
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Explain direct and indirect flat file loading (source file type) - informatica
Difference between Data and Index Caches?