Query to identify the data distribution across AMP's in Teradata


The below query is used to identify the data distribution across AMP's in Teradata


SELECT HASHAMP(HASHBUCKET(HASHROW( index_columns ))) AS AMP_NO ,
COUNT(*)
FROM databasename.tablename
GROUP BY 1
ORDER BY 1;




Comments

  1. anushyaJune 25, 2019 at 11:33 PM

    Excellent article and interesting one to read. I am very glad to see this kind of article. Thanks! keep rocking.
    Ethical Hacking Course in Bangalore
    Hacking Course in Bangalore
    AWS Training in Bangalore
    Devops Training in Bangalore
    Python Training in Bangalore
    Data Analytics Training in Bangalore
    Digital Marketing Training in Bangalore
    Python Course in Bangalore

    ReplyDelete
  2. sandeep saxenaJune 26, 2019 at 5:10 AM


    Feeling so good to read your information's in the blog. Good job!
    Ethical Hacking course in Chennai
    Ethical Hacking Training Institute in Chennai
    Hacking course in Chennai
    ccna Training in Chennai
    Salesforce course in Chennai
    PHP Training in Chennai
    Tally course in Chennai
    Ethical Hacking course in OMR
    Ethical Hacking course in Anna Nagar
    Ethical Hacking course in Vadapalani

    ReplyDelete
  3. AnonymousJune 28, 2019 at 4:45 AM

    Innovative blog...!!! This is the best post and I got more ideas from your post. Keep continuous....
    JMeter Training in Chennai
    JMeter Training
    Power BI Training in Chennai
    Job Openings in Chennai
    Linux Training in Chennai
    Tableau Training in Chennai
    Oracle Training in Chennai
    Oracle DBA Training in Chennai
    JMeter Training in Velachery
    JMeter Training in Vadapalani

    ReplyDelete
  4. Realtime ExpertsFebruary 6, 2021 at 12:01 AM

    Awesome links, it has helped me a lot. Thanks for sharing.
    Teradata Training in Bangalore

    ReplyDelete
  5. UnknownFebruary 11, 2021 at 12:30 AM

    Excellent and Job Oriented training on Bigdata andalysis Course provided by Real Time Experts. Thanks for immediate Placement in Laser Technologies

    Teradata Training in Bangalore

    ReplyDelete

Post a Comment

HTML/JAVASCRIPT

Popular posts from this blog

Teradata SQL Assistant Shortcuts

Teradata SQL Assistant Shortcuts ctrl + T This will clear all the queries in the Teradata Query Editor ctrl + Q This will format the query in the Teradata Query Editor ctrl + D This is used to comment and uncomment the selected query text in the Teradata Query Editor F11 This will get you the last error message ctrl + C This is used to copy the selected Text in the Teradata Query Editor Ctrl + P This is used to paste the copied content into the Teradata Query Editor Ctrl + F This is used to find a Text in Teradata Query Editor Ctrl + H This is used to Find and Replace the Text in Teradata Query Editor Shift + F10 + I This will get you the current date in the Teradata Query Editor F5 This will execute the Query in the Current Query Tab in the Teradata Query Editor F6 This will get you the execution plan for the query in the Query Editor F9 This is used to execute the Query in Parallel.
Read more

Export Informatica Objects using shell script

Export Informatica Objects using shell script Exporting Informatica Objects from Informatica repository using shell script is not a complex one. It is very easy if you understand the functionality of certain commands like pmrep connect  and  pmrep ObjectExport. pmrep connect  is used to connect to a Informatica repository. pmrep ObjectExport  is used to export Objects from Informatica repository. Code to connect to Informatica Server: pmrep connect -r <<repo-name>> -d <<domain-name>>-n <<infa_user>> -x <<infa_pwd>> code to Export Informatica Objects : pmrep ObjectExport -n ${soure_infa} -o workflow -m -s -b -r  -f ${folder} -u ${tgt_infa}
Read more