There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
Can we insert and update a target table without using update strategy transformation?How?
Differentiate between joiner and lookup transformation?
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
What is meant by target load plan?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
What is the difference between procedure and stored procedur?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Explain pushdown optimization $pushdownconfig parameter - informatica
Explain the shared cache and re-cache?