Interested to Buy Any Domain ? << Click Here >> for more details...
If u select groupby port in aggregator what is output and
dont select groupby option what is output
- 2 Answers
- 5742 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ash
If we select a group by port then : we get the last row of
each group based on the group by port.
If we didn't select a group by port: we get only one row
that is the last row .
| Is This Answer Correct ? | 12 Yes | 1 No |
how to load duplicate row in a target
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
Does Facttable Normalized or Denormalized?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
If we set dd_insert in mapping and Delete in session properties what will happen.?
what is the need of session partitioning... how it is useful in real time
What happens if the info. Server doesn't find the session parameter in the parameter file?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
Differentiate between a database and data warehouse?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Teradata 
