Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 4604 Views
- I also Faced
- E-Mail Answers
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
What are the new features of Power Center 5.0?
What are the new features of informatica 9.x at the developer level?
how to load rows into fact table in data warehouse
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Explain how many types of dimensions are available in informatica?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is a sequence generator transformation?
Which are the different editions of informatica powercenter that are available?
What do you mean by filter transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Whats there in global repository
In which transformation you cannot drag ports into it?
What is InformaticaPowerCenter?
How are the sources and targets definitions imported in informatica designer?
How can we use batches?
