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
- 4628 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 |
How to jion 2 tables, without using any condition?
What is informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
HOW TO GET THE LATEST DATA IN SCD ?
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
How do you change a non-reusable transformation to reusable transformation?
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?
What does “tail –f” command do and what is its use as an Informatica admin.
if soource is having 10 records how will u insert 20 records to target
Target increases every day even though no new record was inserted
Teradata 
