split two strings into two columns
For Eg.
Source:-Full Name: Shiva Kumar
First Name:Shiva
Last Name:Kumar

Answer / venky

output1=substr(name,1,instr(name,' ')-1)
output2=substr(name,instr(name,' ')+1)

output1 means firstname
output2 means last name

Is This Answer Correct ?    25 Yes 0 No

Post New Answer

More Informatica Interview Questions

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,

why we use informatica in our project?

2 Answers   TCS,

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  

explain different types of modeling.

2 Answers  

in which situations do u go for starflake schema ?

6 Answers   TCS,

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

What is the functionality of update strategy?

2 Answers  

how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,

what is degenerated dimension table with scenario

0 Answers   HCL,

What is a look up function? What is default transformation for the look up function?

2 Answers   TCS, ASM,

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,