why we use informatica in our project?
- 2 Answers
- 6931 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 |
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
When the informatica server marks that a batch is failed?
When do you use mapping parameters? (In which transformations)
why do we go for update strategy tr in SCD rather using the session properties?
In a concurrent batch if a session fails, can you start again from that session
What is a rank transform?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
can we load the data with out a primary key of a table? what is target plan?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
Explain dynamic target flat file name generation in informatica
On which transformations you created partitions in your project?
Teradata 
