What are the different Lookup methods used in Informatica?
Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?
Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?
What are snapshots?
what are the session parameters? How do u set them?
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
Is hadoop a etl tool?
What is initial load and what is full load?
When do we analyze the tables?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
List few etl bugs?
what are the parts of Informatica server ?