Briefly describe lookup transformation?
No Answer is Posted For this Question
Be the First to Post Answer
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
what is mapping parameter and mapping variables
What are the differences between joiner transformation and source qualifier transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
Briefly explain the aggregator transformation?
create a mapping to retrieve the employees who are getting salary greater than average salary?
Explain informatica architecture - version 8 / 9
If we have lookup table in workflow how do you trouble shhot to increase performance?
What is meant by a domain?
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?