FAST Load error Handling Abort in phase1, Data AQuision in complete:
1) Acquision (File- Amp)} 2)Application(Amp-Table) .Login .Begin Handle load table Error Check point End Load(Amp-Table) .Logoff What is default data conversion supported in fast load? Ans: Char
Data Char
Numeric Numeric
Char Date
Char Numeric
Decimal Fixed text
Varchar
Integer
Decimal Decimal
Integer
How do you load multiple file some structure to a table? [Same structure different file names](or)There is no end loading statement more data acquire then what will you do? Ans There are 2 ways
2nd way
1st way:
FAST Load script fail and error table existed then how do you restart? Ans:1st way: In case of old file to Restart
so that if Runs from last check point Note
.Set Record unformatted; .Run file c:\BTEQ\Conn.TXT; Database vinayaka; Begin Loading party3 Error files erparty3,UVParty3 Check point 10; End loading .Log off Take a new file in the script and run freshly
Why fast load does not support SI,JI,RI And TRIGGER? Ans: The above concept Required communication between Amps, But Fast load Does not support communication between Amp’s And runs independently
You liked the article?
Like: 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.