Could any one to tell Fact table Partitioning?
- 2 Answers
- 5756 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / santhosh kumar n
yes we can partitioning,but we can,t splits fact tables
| Is This Answer Correct ? | 0 Yes | 0 No |
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
A session S_MAP1 is in Repository A. While running the session error message has displayed
if soource is having 10 records how will u insert 20 records to target
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
one source to target loading insert new rows and update existing rows?
how to get flatfile containg 10 records half records one target another half another target
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what is galaxy repository?
Teradata 
