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 |
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
what are the types of Data warehousing ?
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
On which transformations you created partitions in your project?
How union transformation is used?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Explain the different dimensions.
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
What are the uses of a Parameter file?
What are the mapings that we use for slowly changing dimension table?