split two strings into two columns
For Eg.
Source:-Full Name: Shiva Kumar
Target:-
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 ? | 26 Yes | 1 No |
What do mean by local and global repository?
How can informatica be used for an organization?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
Explain joiner transformation in informatica
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
can every transfomation reusable?how?
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
How the informatica server sorts the string values in Rank transformation?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
What is critical mapping?
How to call shell scripts from informatica?