 Related Questions Hi,1.Can anyone explain all the 4 partitions in Informatica and on which table what partition is used?2.Suppose we have 4 columns in a table primary key, 2 string columns and a numeric column? While doing a group by aggregator what is the order that we have to group by?Thanks,Arpita. Read Answers (3) | Asked by : Arpita Latest Answer : We can update the target table, by using the update override in target definition. it will update based on non key columns. ... I am new to the informatica ..Can anyone explain stored procedure,sequence generator and lookup transformation with example... Read Answers (2) | Asked by : kalpana Latest Answer : definatly ... I have a flat file which i am using as my source , i want to match the records in the flat files with that of my oracle table(using cust_id field). I was advised that i should be using a look up transformation and a filter transformation for this. I am not understanding why i should be using the look up transformation. can anyone please helpThanksNayana Read Answers (6) | Asked by : nayana Can anyone please explain how i can write a subquery in the expression editor of a filter transformation (i need the syntax to write in the expression editor)thanksnayana Read Answers (4) | Asked by : nayana How do i get data in a unconnected lookup transformationi.e if i want to compare customer_id in the source with the customer_id in the unconnected lookup, how can i get the data from the source for the customer_id if it is an unconnected lookupthanksnayana Read Answers (2) | Asked by : nayana When we use only Aggregator transformation in our mapping for approx 5 milion records it takes 40-42min time but when we use it with a sorter transformation, the time reduces to 12 -13 min. We have also noticed that throughput of select statement from source was also very high. It aggregates grouped data quickly is ok but why throughput of select statement was also higher using sorter transformation? Latest Answer : Look of transformation we r using to tally the records of source and target.The main things r as under1.To get the related values between source and target.2.Used for caluculation purposes.3.Slowly changing dimensions. ... Read Answers (2) | Asked by : RAGHAVENDRA Latest Answer : Custom transformation To extend the powercenter functionality by using outside developed procedures. You can create Custom transformations with multiple input and output groupsFor any queries: sriram_kumar @ one... ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
