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 / 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 |
what is degenerated dimension table with scenario
what are presession,postsession success and postsession failure commands ?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
Which gives the more performance when compare to fixed width and delimited file ? and why?
How can we handle two sessions in informatica?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
how can u approach u r client
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
How can you generate reports in informatica?
In informatics server which files are created during the session rums?
Global and Local shortcuts. Advantages.