Interested to Buy Any Domain ? << Click Here >> for more details...
why we need informatica
- 2 Answers
- 13506 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mike
well informatica is the tool used for data aquisition
process..which is nothing but data extraction, data
transformation and data loading. Inorder to build a data
ware house we use informatica
or
It is a GUI tool and we need informatica for
running,designing,monitoring and administrating the data
flow from various external source and internal sources to
the data ware house
correct me if i was wrong
| Is This Answer Correct ? | 19 Yes | 2 No |
Answer / deepthi
etl's r of 2 types.code based n gui based.in code based etl
we have some limitations.inorder 2 over come those
limitations we use gui based etl ninformatica is 1 among
the gui.
| Is This Answer Correct ? | 3 Yes | 2 No |
how many types of dimensions are available in informatica?
what is the difference between stop and abort?
what is lookup chache?
What is the difference between writing a joiner query in ANSI style and THETA style?
what is left outer join?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
what is the difference between lookupoveride and joiner?
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
Which is the t/r that builts only single cache memory?
In joiner, how to load Master table in Target?
Teradata 
