I have to find 2 highest salary from each depart, and employee should have tenure more then 5 years. Table has emp id, name, salary, depart, DOJ. Tried but getting only for 1 depart not for all and no idea about the timestamp, how to subtract to see the tenure.. please advise new in hive still studying for future (: Thanks

How is transaction time typically represented in a dimensional model

Where can we see the number of rows fetched for the last execution time?

I want to create a job which takes input file (containing metadata only) and creates dummy records based on the metadata. Is it possible?

How to do peformance tuning in SQl..??? what are the things involved in tuning..??

How to test workflow in informatica? And how to do ETL testing in Unix?

As I am new to Informatica. Can anybody tell me about real time
Informatica project in detail(step by step). Explain it by giving example.

Can any one explain about master data? and we use it frequently or rarely.

I have source like a,b,c 1,2,3 I want to populate the records in to target as follows
a 1
b 2
c 3

can any body tell me how to solve the scenario by using Transformer Stage.(In Data Stages)

How to create sequencer in datastage(parallel)?

What is the purpose of sequencer and how to create in real time project in parallel?

How do we increase Hash file size?

How can I load rejected data file?
Is it necessary to create new mapping for that.....How can I load by reject data utility explain me clearly

What is the Central Repository? Is it possible to login from designer?

What are the prioritized Rules in Transform function?

How to get rejected data from the join stage without using any stages after join?

How can we remove duplicates from fact table?

What is a custom dimension?