Interested to Buy Any Domain ? << Click Here >> for more details...
Why FLOAD does not support multiset tables??
- 3 Answers
- 14040 Views
- TCS, Tesco, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / adi
Fload will allow multiset table. But there is no advantage
of loading multiset table using fload, becuase fload does
not insert duplicate rows. If we try to load multiset table
using fload with duplicate rows, they fload inserts
distinct rows into the target table and the duplicate row
count displayed under second error table.
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / yuvaevergreen
Fastload utility does not support duplicate rows.
1.Since MS table supports dup rows fastload cannot load MS
table.
2.Restart logic is one of the reason. Fastload is one of the
utility which loads data in blocks(64K). During restart
Fastload sends some of the rows for the second time which
occur after a checkpoint. Due to this Fastload rejects
duplicates.
For example consider 20 rows to be loaded in a table. FL
utility is used to load the table and ckpt is 5 rows. If
restart occurs after 7th row FL may send 6 and 7th to AMPs
during the restart. This records would be considered as
duplicates and rejected.
| Is This Answer Correct ? | 12 Yes | 2 No |
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
can we load 10 millions of records into target table by using tpump?
what is use of PI(primary index) AND SI(secondary index)
what are the uses of fact table and dimension table in banking project?
During the Display time, how is the sequence generated by Teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What is real time and near real time data warehousing?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
0 Answers Infosys, Wells Fargo,
How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance
Teradata 
