why we use informatica in our project?
- 2 Answers
- 6502 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pradosh
this is a stupid Question,
informatica is a ETL tool which is extract,transfoemation,and load data from source to target,bcz our project based on informatica tool so we used
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / ramesh
At Knack systems we use Informatica to make data migration
projects more standardized, repeatable, and consistent.
Whether they are rationalizing, integrating, upgrading, or
migrating to enterprise applications, Our teams can reduce
project risk and cost and improve project predictability
with Informatica.
Informatica makes projects less risky, reduce costs, and
shorten their project cycle Times . It enables users to
migrate more data of a higher quality faster, which means
that we can deliver their projects at a lower cost, on
time, on budget, and without reductions to scope
| Is This Answer Correct ? | 0 Yes | 0 No |
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
What is deployemnt groups, Lables, query and dynamic deployment group.
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
In real time scenario where can we use mapping parameters and variables?
normalizer transformation
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
whatis the default data driven operation in informatica
Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
what is the size of u r source(like file or table)?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
Teradata 
