Is it any possible to using more than one port in Unconnected
Lookup Transformation( :LKP.LKP_Prod(Prod_GRP
,Prod_DT,Prod_TM) ) Like this? Pls explain...
- 3 Answers
- 6827 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gm
As per my knowledge u can't use like this.
u can follow below the below procedure:
first_name, second_name --->Make it one column
name =concat(first_name,second_name) or
name = first_name || second_name
Now u can use as a one port.
u get the multiple columns like the only...
Correct me If I'm wrong.
Best Regards,
GM
| Is This Answer Correct ? | 4 Yes | 1 No |
Explain the etl program with few examples.
What are ETL Tools?
hi all, Can anyone please tell me the relationship between informatica and business objects
What is dimensional table?
why union is active transformation?
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
what is mapping override?
Differentiate between a database and data warehouse?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Teradata 
