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
1/15
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.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox