My source contains 10 records with 5 columns.What happens if I
select group by all columns in Aggregator T/R?
- 3 Answers
- 6879 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhinaw prakash
If u group by all the columns it will group the Data
sequentially according to the Port order and send it to the
Next transformation.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is lookupoverriding?
When you move from devel to prod how will you retain a variable
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
Briefly define reusable transformation?
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
what is diff b/t sorter t/r and agg have the option sorter property...
What is power center repository?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
What are the methods for creating reusable transforamtions?
Differentiate between joiner and lookup transformation?
Teradata 
