What is the need of etl tools?
No Answer is Posted For this Question
Be the First to Post Answer
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
Do joiner transformation use cache? If so describe?
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
Where is metadata stored?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
what is upstream and downstream transformation?