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
Explain the informatica workflow?
What are the differences between a connected lookup and unconnected lookup?
What do mean by local and global repository?
what is the size of your data warehousing?
How do you set a varible in incremental aggregation
According to his methodology what all you need before you build a datawarehouse
What are the different transaction levels available in transaction control transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
What do you mean by worklet?
can anyone suggest best free Talend data integration training online
Explain the different dimensions.
Mention a few design and development best practices for informatica?
How do you change a non-reusable transformation to reusable transformation?
Write the different tools in the workflow manager?
What is a connected transformation?