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?
How to eliminate duplicates in FF and oracle both
how DTM buffer size and buffer block size are related
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
If u r using dynamic cache lookup port will be thier in thet which option u will select
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
What is diff joiner and lookup
ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz
What is the function of look up transformation?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
How to generate a single mapping for both the historical and incremental load.
What is a dimensional model?
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd