HOW TO YOU LOAD TIME DIMENSION
How to do unit testing in informatica?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What does reusable transformation mean?
i have two source data there is no pk,fk how to join the two sources
if i am having 10 records in source, i want 20 records in target...how will you do it
What is a joiner transformation and why it is an active one?
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
What is the difference between bitmap and btree index?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are the differences between a connected lookup and unconnected lookup?
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica