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
- 4523 Views
- I also Faced
- E-Mail Answers
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 |
There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,
What is confirmed dimension with scenario
what are objects in data warehouse?
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
what are the limitation of sorter transformation?
How many number of sessions that u can create in a batch?
how to declare array in plsql?
Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?
What is the difference between informatica 8.x and 9.x
Can we change Dynamic to Static or Persistent cache? If so what happens?
Where is the cache stored in informatica?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
Teradata 
