list the transformation used for the following:Heterogeneous
sources,Homogeneous sources,Find the 5 highest paid
employees with in a dept,create a summery table,generate
surrogate keys
Answer Posted / nagesh
For Heterogeneous sources,use joiner transformation
Homogeneous sources go for source qualifier transformation
TOP 5 SAL
SELECT ROWNUM,ENAME,SAL FROM (SELECT ENAME,SAL FROM EMP
ORDER BY SAL DESC)
Where rownum <6
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Explain the key challenges that you face while performing etl testing.
What is meant by incremental load?
what is the use of structures?how many nodes can u create in a structure?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
Define slowly changing dimensions (SCD)?
What are the names of the layers in etl?
What are materialized views & where do we use them?
How can we use external procedural logic in informatica?
what are the facilities provided by data warehouse to analytical users?
what is session partitioning?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Explain the difference between etl tool and olap tools?
What are the steps involved in etl process?
What is tracing level? How many types of transformations supported by sorted input?
When do we analyze the tables?