What is the difference between a connected look up and unconnected lookup?
No Answer is Posted For this Question
Be the First to Post Answer
What is a stored procedure transformation?
how to load only the first and last record of a flat file into the target?
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
Explain joiner transformation in informatica
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
Where can we find the throughput option in informatica?
How to create or import flat file definition in to the warehouse designer?
How do we call shell scripts from informatica?