Interested to Buy Any Domain ? << Click Here >> for more details...
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
- 1 Answers
- 1528 Views
- I also Faced
- E-Mail Answers
Answer / ysindhureddy77@gmail.com
If we do not use an input port in group-by neither in aggregate expression, the Integration Service
will return only the last row value of the column for the input rows.
For example, if we have 100 rows coming from source then aggregator will output only the last record (100th
record)
| Is This Answer Correct ? | 0 Yes | 0 No |
How the facts will be loaded? explain
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How can we integrate different flat file data in a single mapping and with in a single execution
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
what is the complex transformation you used in informatica
How to partition the Session?
How might you approve all mappings in the archive all the while?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
Can we update the data in flat file using update strategy?
how can one come to know wether the records loak into the target if we use update strategy
wf dont have integration severances how you can run?
Teradata 
