If u select groupby port in aggregator what is output and
dont select groupby option what is output
- 2 Answers
- 4742 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 |
Explain what are the different types of transformation available in informatica.
Did u used latest transformations of 8.6.0? for what?
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
How do you load only null records into target? Explain through mapping flow.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Explain the use of aggregator cache file?
What is union transformation in informatica?
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?
What are the restrictions of union transformation?
What is informatica metadata and where is it stored?
Teradata 
