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
- 4621 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
Differentiate between Load Manager and DTM?
Explain why we use partitioning the session in informatica?
What is the benefit of partitioning a session?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Differentiate between source qualifier and filter transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is confirmed fact in dataware housing?
What is the difference between source qualifier transformations source filter to filter transformation?
What is the different lookup cache(s)?
lookup transformation with screenshots
What is joiner transformation in informatica?
