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
- 3816 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 informatica process data means how informatica works?
which one is better either active or passive transformation in informatica
why do we go for update strategy tr in SCD rather using the session properties?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
While migrating the data from one environment to another environment how would you manage the connections?
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
Why we use partitioning the session in informatica?
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
How can i set break points in debugging mode ? can explain steps please?
pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?
Teradata 
