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...
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 |
In which circumstances that informatica server creates Reject files?
What is the session task and command task?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
What is repository manager?
what is the difference between informatica6.1 and infomatica7.1
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
What is complex mapping?
how can import the data from the flat files?
What is aggregate cache in aggregator transformation?