Interested to Buy Any Domain ? << Click Here >> for more details...
why we use informatica in our project?
- 2 Answers
- 7310 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 |
What is the reusable transformation?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain how to import oracle sequence into informatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
In dimension and fact table? which one holds big data?
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
Teradata 
