![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() Related Questions Latest Answer : In Session properties SELECT treat source rows as UPDATE
In Target properties of session SELECT Insert, Update works like it updates if row is existing or Insert if the row is not existing. ... 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 : Normalization is used to transform non tabular data structure into tabular format mainly required for COBOL data files. ... Read Answers (1) | Asked by : malik When i start the informatica services for loading in workflow manager, the informatica services shows runing status but when i see the properties service, status has stoped. With-in sec services has stoped when i was trying to start the services for informatica, how can i overcome this problem? Read Answers (1) | Asked by : raj 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 (3) | 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 View Question | Asked by : Rema 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?
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||