-
-
-
Dimensional Model Transaction Time
How is transaction time typically represented in a dimensional model
-
DataStage - Flat File Concat Header
I have a file with 1000 rows I need to split this file that each 100 row is split by a header, to make more clear I need to concatenate the header after 100 row
-
Read nth Row from a File using Sequential File Stage in Datastage
How to read nth Row from a File using Sequential File Stage in Datastage
Scenario is as follows:
I have only two stages in a job
SeqFileStage1------> SeqFileStage2
I have to read only 6th Row from File 1 and write it in File2. -
Find 2 highest salary from each depart who have completed 5 years in org.
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
-
-
Ab initio Graph Development
How to move the Ab initio graph development to Production or QA?
Data Warehousing Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans