on how many columns we can perform aggregation in the
Aggregator stage?
Answers were Sorted based on User's Feedback
Answer / ramesh
any number of columns we can perform aggregation
ex:group by deptno,group by deptname,
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / devendra singh
any no of columns we can aggregate in aggregation stage
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / kiran
Depends upon Requirement....u can apply aggregations
| Is This Answer Correct ? | 2 Yes | 3 No |
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records
What is oci?
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
What is job control?
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers
1)Source file contains one record, I want 100 records in target file.
what is the use of skid in reporting?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?
How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?
how many dimentions and fact tables used in your project and what are names of it?
what is factless fact table?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name