Tableau :- Tableau is market leader in the BI software world, it allows business users to understand their data, then visualize and create interactive, sharable dashboards. Tableau is so simple to operate that even a non technical Excel user can learn it, but powerful enough to satisfy even the most complex analytical problems. Securely sharing your findings with... Read More »
Testing in data warehouse(DW) is always consider to be an time consuming and teddies process , it requires good understating of the data modeling which we are testing and good understanding of underlying data and business requirement .DW Testing broken into smaller strategies ETL Phase:- ETL phase... Read More »
Companies are investing so much money to understand data they have accumulated for so many years and what value it can can potentially provide. Hadoop plays an major role in processing/handling Big data ,Hadoop (HDFS) is simply a file system in which the data files are distributed across multiple computer systems (nodes). A Hadoop cluster is a set of computer systems which function... Read More »
The Internet of Things (IoT) is one of the hottest topic in every industry, many organization wants to get an understanding on this and invest/learn and implement in the IoT. Many IT professionals(including me) wants' to learn this skill and get's a hands-on-experience on IOT Leading Iot Players :- ARM IBM CISCO Google Bosch Ericsson GE Intel Microsoft ThingWorx Axeda PTC You can... Read More »
I had a requirement where we need to send more than one set of files to Mainframe using Datastage, the catch was, each file had different set columns and length. I have spent quite a bit of time coming up with a job which can process more than one file with different layout and length Here you go…. Sequence File Stage :- ... Read More »
Query Tab Ø If only one query, name it ‘Query_report name’. If multiple, it should have the ‘Query_’ prefix with something that reflects the query’s purpose. (e.g. The name of the fact table it uses) Report Tab Ø If only one tab, it should match the report title. If multiple, it should briefly reflect the purpose of the sub-report. Report Header Ø Report... Read More »
This is collection which I collected from across net for list of question you can get on Talend 1. Difference between tMap and tJoin component in Talend . 2. Difference between tAggregaterow and tAggregatesortedrow. 3. Difference between tJava,tJavarow,tJavaflex. 4. How to improve the performance of Talend job having complex design? 5. Difference between built in schema and Repository. 6. What is the declaration... Read More »
Metadata management has become a key area in the company's to keep track of information's passing through many gates and understand it's value and how it's getting changed from one BU and another Why Data Lineage :- Lets imagine that an user has complained about user having multiple records with different customer information's.To understand the root cause of this in current world without... Read More »
What is ETL Mapping Document ?A Real Time Example
Netezza Performance Check Querys
Netezza Commands
Netezza ISNUMERIC Data Check Logic
Use of Default or Dummy row in dimension table
Datastage Error and reject record Handling simplified
Datastage Universe Quick Refrence
Optimizing Business Objects Universe and Reports
DataStage and Slowly Changing Dimensions
Data Generation Using DataStage
