while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

How many nodes supported by a one cpu in parallel jobs?

How do we Mass update the price of a material in billing docs if the price of item is changed after creation of order, delivery and pgi. We want the billing to happen at revised rae.

Write the regular expression code, it accepts the alpha, numeric and special symbol and the first character should be the Alphabet. Tell me the answer

What is a complete process of SAP SD support & how ticket will come from customer to SAP support team and after solving ticket what support member will do and how that solved ticket will reach to customer ?

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

please inform me , how to make employee ladger account of salary...please inform me with entry..e.g if we give 14000 salary, as structure we put it half amount in advance and half is salary so in this case how to make entry in employee ledger account...please inform me...both things..Thank You.

differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??

How to backup/resore Group Policy objects....?

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

I have two files , file1 is input file it contains 10,20,30,....,records but i want to display the records in file 2 as reverse order .how can we do by using jcl& cobol(dont use array) please any one can tell me the answer

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

if i am having 10 records in source, i want 20 records in target...how will you do it

What is differnce between Error code and Error Level in Bteq

Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table