My source contains 10 records with 5 columns.What happens if I
select group by all columns in Aggregator T/R?
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 |
Define error Threshold?
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
What is the advantage of informatica?
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
what is Partitioning ? where we can use Partition?
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the active and passive transforamtions?