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
- 4524 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 is union transformation in informatica?
What is DR strategy for Informatica project?
What do mean by local and global repository?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Target increases every day even though no new record was inserted
What do think which one is the better joiner or look up?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How to join three sources using joiner?
What is the procedure for creating independent data marts from informatica 7.1?
What are the measure objects?
Mention few advantages of router transformation over filter transformation.
can anyone suggest best free Talend data integration training online
Is it possible to use a client with different version than that of its Informatica server?
How to use procedural logic inside infromatica?
