What are the ETL tools available in DWH?

Answer Posted / rekha

INFORMATICA
ABINITIO
DATASTAGE
HYPERION

Is This Answer Correct ?    19 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Target increases every day even though no new record was inserted

1220


What is the way to execute pl/sql script using informatica mapping?

1082


what is song in infrmatica...?

1812


Explain about Informatica server process that how it works relates to mapping variables?

714


Why update strategy and union transformations are active? Explain with examples.

815






tell me the rules and responsblites in our project(my project is development)

1604


What are the types of lookup transformation?

724


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

766


what is mean by complex business rule ?

1800


where to store informatica rejected data?

766


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1734


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1233


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1556


r u done any partitions in ur project?

1475


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1765