How can we get two output ports in un-connect transformation?
Answers were Sorted based on User's Feedback
Answer / prabhu
You can use lookup override to concat two columns from tble
and return as single column(eg COL1||','||col2 as
COLUMN).You can pass this to expression transformation and
parse it to split it again
Prabhu
www.iskilltech.com
Is This Answer Correct ? | 9 Yes | 0 No |
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
Explain lookup transformation in informatica
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
What is informatica powercenter repository?
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,
create a mapping to retrieve the employees who are getting salary greater than average salary?
What are the different caches used in informatica?
What are the types of lookup?
What is a repository? And how to add it in an informatica client?
What is parallel processing in informatica?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?