1)you have multiple source system where u receive files ,how
do you actually load into mapping using transformation,what
are the transformation you use?
2)you have files in ftp location ,how do you get it into
mapping with you ETL concept?
No Answer is Posted For this Question
Be the First to Post Answer
Can we insert ,update ,delete in target tables with one update strategy tran.?
what is the difference between Informatica7.1 & informatica 8.1
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
What are different types of transformations available in informatica?
What is a dimensional model?
why we are using surogate key in real time give me explanation
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
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
What is the difference between SOURCE and TARGET BASED COMMITS?
How can you complete unrcoverable sessions?
where to select code page option?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,