split two strings into two columns
Source:-Full Name: Shiva Kumar
Answer / venky
output1 means firstname
output2 means last name
|Is This Answer Correct ?||25 Yes||0 No|
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
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.
why we use informatica in our project?
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
explain different types of modeling.
in which situations do u go for starflake schema ?
How to eliminate duplicate records in informatica mapping? Explain with an example....
What is the functionality of update strategy?
how u know when to use a static cache and dynamic cache in lookup transformation.
what is degenerated dimension table with scenario
What is a look up function? What is default transformation for the look up function?
how we can load rejected record's at run time?(not through bad files)